Editing Data control language (section)

== MySQL ==
[[MySQL]] server they divide SQL statements into different type of statement
* Data Definition Statements
* Data Manipulation Statements
* Transactional and Locking Statements
* Replication Statements
* Prepared Statements
* Compound Statement Syntax
* Database Administration Statements
* Utility Statements

For details refer [https://dev.mysql.com/doc/refman/8.0/en/account-management-statements.html MySQL Transactional statements]<ref>{{Cite web|title=MySQL :: MySQL 8.0 Reference Manual :: 13.7.1 Account Management Statements|url=https://dev.mysql.com/doc/refman/8.0/en/account-management-statements.html|access-date=2020-09-19|website=dev.mysql.com}}</ref>

The grant, revoke syntax are as part of Database administration statementsàAccount Management System.

The GRANT statement enables system administrators to grant privileges and roles, which can be granted to user accounts and roles. These syntax restrictions apply:
* GRANT cannot mix granting both privileges and roles in the same statement. A given GRANT statement must grant either privileges or roles.
* The ON clause distinguishes whether the statement grants privileges or roles:
* With ON, the statement grants privileges
* Without ON, the statement grants roles.
* It is permitted to assign both privileges and roles to an account, but you must use separate GRANT statements, each with syntax appropriate to what is to be granted.

The REVOKE statement enables system administrators to revoke privileges and roles, which can be revoked from user accounts and roles.

=== 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>