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 (privilege) Statement.)
You cannot revoke privileges granted by other users.
Syntax:
revoke
all [privileges] | privilege {, privilege} | object_name {, object_name}
[on object_type]
from public | [auth_type] auth_id {, auth_id};
Last modified date: 12/20/2023