Syntax for Securing Database Resources › GRANT Administration Privilege › GRANT Administration Privilege Parameters

GRANT Administration Privilege Parameters

DBADMIN

Specifies that you are giving DBADMIN privilege on the database identified in the ON parameter to the users or groups identified in the TO parameter.

ON DB database-name

Specifies the database to which DBADMIN privilege applies.

Database-name refers to either the name of a segment or a database name entry in the database name table.

DBADMIN controls access to database resources. A user with DBADMIN privilege can grant and revoke privileges for the specified database. DBADMIN privilege also allows users to maintain physical database definitions in the dictionary identified by database-name.

Note: For more information about the DBADMIN privilege, see Securing Database Resources.

You can wildcard database-name.

Note: For more information about wildcarding, see Using a Wildcard.

TO

Specifies the users or groups to whom you are giving DBADMIN privilege.

PUBLIC

Specifies all users.

Important: If you grant DBAMIN to group PUBLIC, any user can administer security on the database.

authorization-identifier

Identifies a user or group.

Note: Expanded syntax for authorization-identifier is presented in Notes on Security Statement Syntax.

Granting DBADMIN to the DBA

The following statement grants DBADMIN privilege on database GLDB to the DBA group ID:

grant dbadmin
  on db gldb
  to dba_gldb;