Granting RESOURCE Authority to a User

RESOURCE authority allows the user to create new database objects, such as tables, views, indexes, or procedures.

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 RESOURCE TO userid
Parent topic: Managing Individual User IDs and Permissions