Syntax for Securing Database Resources › REVOKE Administration Privilege › Parameters

Parameters

DBADMIN

Specifies that you are revoking DBADMIN privilege on the database identified in the ON parameter from the users or groups identified in the FROM parameter.

ON DB database-name

Specifies database to which DBADMIN privilege applies.

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

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.

FROM

Specifies the users or groups from whom you are revoking DBADMIN privilege.

PUBLIC

Specifies all users.

The privilege must have been previously given to PUBLIC by means of the GRANT statement.

authorization-identifier

Identifies a user or group.

The privilege must have been previously given to authorization-identifier by means of the GRANT statement.

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

Revoking DBADMIN From the DBA

The following statement revokes DBADMIN privilege on database GLDB from the DBA group ID:

revoke dbadmin
  on db gldb
   from dba_gldb;