Database-Level Privileges
Use this page to manage privileges for users of a database.
Only individual users, not roles, can hold database-level privileges. Only a user with the DBA privilege can grant or revoke database-level privileges.
- Database
- Use this list to select the database.
- User
- The user name of the user with the database-level privilege.
- Privilege
The database-level privilege for the user:
- CONNECT
- Allows a user to connect to a database, to query and modify data, to modify the database schema if the user owns the database object, and to perform related operations.
- RESOURCE
- Includes all the capacities of the Connect privilege and allows a user to create tables, indexes, UDRs, and data types.
- DBA
- Includes all the capabilities of the Resource privilege and allows a user to perform additional DBA functions.
- Default Role
- The default roles assigned by an administrator to individual users or to the PUBLIC group for the database.
- Modify
- To change the database-level privilege for the user shown in the row, click Modify and select the privilege. To cancel the privilege, select Revoke.
- Grant new privilege
- To grant a database-level privilege to a user, enter the user name, select the privilege, and click Grant.