ASA Database Administration Guide
  Managing User IDs and Permissions
    Managing individual user IDs and permissions

Granting DBA and RESOURCE authority

You can grant DBA and RESOURCE authority in the same manner.

To grant RESOURCE permissions to a user ID

1. Connect to the database as a user with DBA authority.

2. Type and execute the SQL statement:

   GRANT RESOURCE TO userid

For DBA authority, the appropriate SQL statement is:

GRANT DBA TO userid

Notes 

• Only the DBA may grant DBA or RESOURCE authority to database users.

• DBA authority is very powerful, since anyone with this authority has the ability to carry out any action on the database and as well as access to all the information in the database. It is wise to grant DBA authority to only a few people.

• Consider giving users with DBA authority two user IDs, 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, procedures, or triggers.