|
You can grant DBA and RESOURCE authority in the same manner.
Connect to the database as the DBA.
Execute the SQL statement:
GRANT RESOURCE TO user-id;
For DBA authority, the appropriate SQL statement is:
GRANT DBA TO user-id;
Only the DBA can grant DBA or RESOURCE authority to database users.
DBA authority is very powerful: anyone with this authority has the ability to perform any action on the database, 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 who need 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.