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.
Granting RESOURCE
permissions to a user ID
Connect to the database as a user with DBA or PERMS ADMIN authority.
Type and execute the following SQL statement:
GRANT RESOURCE TO userid
Granting
DBA permissions to a user ID
Connect to the database as a user with DBA authority.
Type and execute the following SQL statement:
GRANT DBA TO userid
Granting
OPERATOR permissions to a user ID
Connect to the database as a user with DBA or PERMS ADMIN authority.
Type and execute the following SQL statement:
GRANT OPERATOR TO userid
Granting PERMS ADMIN permissions to a user ID
Connect to the database as a user with DBA or PERMS ADMIN authority.
Type and execute the following SQL statement:
GRANT PERMS ADMIN TO userid
Granting
RESOURCE permissions to a user ID
Connect to the database as a user with DBA or PERMS ADMIN authority.
Type and execute the following SQL statement:
GRANT RESOURCE TO userid
Granting SPACE ADMIN permissions to a user ID
Connect to the database as a user with DBA or PERMS ADMIN authority.
Type and execute the following SQL statement:
GRANT SPACE ADMIN TO userid
Granting
USER ADMIN permissions to a user ID
Connect to the database as a user with DBA or PERMS ADMIN authority.
Type and execute the following SQL statement:
GRANT USER ADMIN TO userid
Only the DBA can grant DBA authority to database users.
DBA authority is very powerful, granting the ability to carry out any action on the database and access to all the information in the database. It is generally inadvisable to grant DBA authority to more than a very few people.
You should give two user IDs to users with DBA authority—one with DBA authority, and one without—so that they connect as DBA only when necessary.
RESOURCE authority allows the user to create new database objects, such as tables, views, indexes, or procedures.
