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.) 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};