Granting SPACE ADMIN Authority

Most authorities are granted in the same manner. DBA authority can grant any authority. PERMS ADMIN authority can grant any authority except DBA and REMOTE DBA.

  1. Connect to the database as a user with DBA or PERMS ADMIN authority.
  2. Type and execute the following SQL statement:
GRANT SPACE ADMIN TO userid
Parent topic: Managing Individual User IDs and Permissions