Editing Data control language (section)

=== Examples ===
{{sxhl|2=mysql|
REVOKE INSERT ON *.* FROM 'jeffrey'@'localhost';

REVOKE 'role1', 'role2' FROM 'user1'@'localhost', 'user2'@'localhost';

REVOKE SELECT ON world.* FROM 'role3';

GRANT ALL ON db1.* TO 'jeffrey'@'localhost';

GRANT 'role1', 'role2' TO 'user1'@'localhost', 'user2'@'localhost';

GRANT SELECT ON world.* TO 'role3';
}}
In [[PostgreSQL]], executing DCL is [[Database transaction|transactional]], and can be rolled back.

'''Grant''' and '''Revoke''' are the SQL commands are used to control the privileges given to the users in a Databases

[[SQLite]] does not have any DCL commands as it does not have usernames or logins. Instead, SQLite depends on [[file-system permissions]] to define who can open and access a database.<ref>Kreibich, J.A., 2010. [https://books.google.com/books?id=HFIM47wp0X0C Using SQLite], O’Reilly.</ref>