Granting PERMS ADMIN Authority to a User

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 PERMS ADMIN TO userid