SQL DML Commands

DCL Commands in SQL

Data Control Language(DCL) are used to control access to data stored in a database. You can say in database language DCL are used to control privilege in database.

DCL Commands

• Grant: to allow specified users to perform specified tasks.
• Revoke: to cancel previously granted or denied permissions.

To allow user to create session

To allow user to create table

	
grant to create table to username;

To give all privilage to user

	
grant sysdba to username;

To take back permision

	
revoke create table from username