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;
Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.