Revoke Statement
The revoke statement revokes privileges. It removes database privileges or role access granted to the specified users, groups, roles, or PUBLIC. (To confer privileges, use the
grant statement (see
Grant (privilege) Statement).)
You cannot revoke privileges granted by other users.
This statement has the following syntax:
revoke
all [privileges] | privilege {, privilege} | object_name {, object_name}
[on object_type]
from public | [auth_type] auth_id {, auth_id};