REVOKE Administration Privilege 1

Revokes from one or more users or groups the DBADMIN privilege.
idms
Revokes from one or more users or groups the DBADMIN privilege.
Authorization
To revoke DBADMIN privilege, you must hold one of these privileges:
  • DBADMIN on the database
  • SYSADMIN
You must be connected to the system dictionary when you issue the statement.
Syntax
►►─── REVOKE DBADMIN ON DB 
database-name
 ─────────────────────────────────────►               ┌─────────────── , ──────────────┐  ►─── FROM ─▼─┬─ PUBLIC ───────────────────┬─┴────────────────────────────────►◄               └─ 
authorization-identifier
 ─┘
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.
    For more information on the DBADMIN privilege, see Securing Database Resources.
    You can wildcard
    database-name
    .
    For more information on 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.
    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;