Oracle SQL: the Essential Reference

REVOKE (System Privilege or Role)

REVOKE {privilege | role}[,{privilege | role} ...] FROM {username | rolename | PUBLIC}[,{username | rolename | PUBLIC} ...]

Removes a system privilege or role from one or more users and/or roles.

Keywords

privilege

Specifies the name of a system privilege to be revoked.

role

Specifies the name of a role to be revoked.

username

Specifies the name of a user from whom a privilege or role is to be revoked.

rolename

Specifies the name of a role from which a privilege or role is to be revoked.

PUBLIC

Specifies that the granted privilege or role no longer be available to all users by default.

Examples

Revoke the account_admin role from scott and debby:

REVOKE account_admin FROM scott,debby;

Revoke the CREATE USER and DROP USER privileges from the dba_assist role:

REVOKE create user, drop user FROM dba_assist;