SQL Guide : solidDB® SQL statements : REVOKE
  
REVOKE
REVOKE { role_name [, role_name ]... }
  FROM {PUBLIC | user_name [, user_name ]... }
REVOKE
  {ALL | revoke_privilege [, revoke_privilege]... } ON table-name
  FROM {PUBLIC | user_name [, user_name]... |
  role_name [, role_name]... }
revoke-privilege ::= DELETE | INSERT | SELECT |
  UPDATE [( column_identifier [, column_identifier]... )] |
  REFERENCES
REVOKE EXECUTE ON procedure_name
  FROM {PUBLIC | user_name [, user_name]... | role_name
  [, role_name]... }
REVOKE {SELECT | INSERT} ON event_name FROM
  {PUBLIC | user_name [, user_name]... | role_name
  [, role_name]... }
REVOKE {SELECT | INSERT} ON sequence_name
  FROM {PUBLIC | user_name [, user_name]... |
  role_name [, role_name]... }
Usage
The REVOKE statement removes a role from users or privileges from users and roles.
Note The keywords CASCADE and RESTRICT are not supported in REVOKE statements.
Examples
The following command removes the role GUEST_USERS from the user HOBBES:
REVOKE GUEST_USERS FROM HOBBES;
The following command removes the priviledge to insert on event TEST from the role GUEST_USERS:
REVOKE INSERT ON TEST FROM GUEST_USERS;
Related reference
GRANT
Related information
Managing user privileges and roles
See also
solidDB® SQL statements