REVOKE (Object Privileges)
REVOKE {object_priv
[,object_priv
...] | ALL [PRIVILEGES] } ON [schema
.]object_name
TO {username
|role
| PUBLIC}
Revokes privileges on a database object (object_name) for one or more users (username) or roles (role).
Specifies the name of the object privilege to be revoked. Valid privileges are: ALTER, DELETE, EXECUTE, INDEX, INSERT, REFERENCES, SELECT, and UPDATE. ALL PRIVILEGES revokes all privileges granted for this object.
Specifies that the object privilege will be revoked for all current and future users.