Data Control Language DCL
Data Control Language DCL: Data Authorization Statements
GRANT <privilege>[, <privilege>...] [ON <object type> <object name>] TO <user>[, <user>]...
[WITH GRANT OPTION];
| Object | Object Type | Privileges |
|---|---|---|
| Column Attribute | Table | SELECT, INSERT, UPDATE, DELETE, ALL PRIVILEGES |
| View | Table | SELECT, INSERT, UPDATE, DELETE, ALL PRIVILEGES |
| Base Table | Table | SELECT, INSERT, UPDATE, ALTER, INDEX, ALL PRIVILEGES |
| Database | Database | CREATE TABLE (permission to create tables), grantable by DBA to regular users |
Revoke Permissions
REVOKE <privilege>[, <privilege>...] [ON <object type> <object name>]
FROM <user>, [<user>]