can take back privilege to default one, in this case, we take back command INSERT on the table employees for user User1. DENY is a specific command. We can conclude that every user has a list of privilege which is denied or granted so command DENY is there to explicitly ban you some privileges on the database objects.: Oracle Database Oracle Database divide SQL commands to different types. They are. Data Definition Language (DDL) Statements Data Manipulation Language (DML) Statements Transaction Control Statements Session Control Statements System Control Statement Embedded SQL Statements For details refer Oracle-TCL Data definition language (DDL) statements let you to perform these tasks: Create, alter, and drop schema objects Grant and revoke privileges and roles Analyze information on a table, index, or cluster Establish auditing options Add comments to the data dictionary So Oracle Database DDL commands include the Grant and revoke privileges which is actually part of Data control Language in Microsoft SQL server. Syntax for grant and revoke in Oracle Database: Example Transaction Control Statements in Oracle Transaction control statements manage changes made by DML statements. The transaction control statements are: COMMIT ROLLBACK SAVEPOINT SET TRANSACTION SET CONSTRAINT MySQL MySQL server they divide SQL statements into different type of statemen 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 MySQL Transactional statements 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 In PostgreSQL, executing DCL is 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