Granting USER ADMIN Authority to a User

USER ADMIN authority lets you manage external logins, login policies, and other users.

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