REVOKE

REVOKE — remove access privileges from users and/or roles.

Syntax

REVOKE rolename [, ...] FROM username
          
REVOKE { SELECT | INSERT | UPDATE | DELETE | EXECUTE | ALTER | GRANT | TRIGGER  
       | ALL  [ PRIVILEGES ]
      }  
      ON { tablename | ALL TABLES IN schemaname } FROM ROLE rolename [, ...] 
  
REVOKE { SELECT | INSERT | UPDATE | DELETE | EXECUTE | ALTER | GRANT | TRIGGER  
       | ALL  [ PRIVILEGES ]
      }  
      ON { tablename | ALL TABLES IN schemaname } FROM username [, ...] }
 
REVOKE { ALTER | EXECUTE } ON PROCEDURE procedure_name FROM username
REVOKE { ALTER | CREATE } ON SCHEMA schemaname FROM username

Description

Removes access privileges. Use the REVOKE statement to:

The REVOKE ALL ON ALL TABLES statement removes privileges on the tables in a schema but not on the schema itself.
To remove a user's privilege to create tables, views, SQL domain types and sequences in a schema, use the REVOKE CREATE ON SCHEMA statement. To remove a user's privilege to drop a schema, use the REVOKE ALTER ON SCHEMA statement.

Parameters

Examples