SQL DML Commands

Prev Tutorial Next Tutorial

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 command

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

Prev Tutorial Next Tutorial

Google Advertisements
Download Projects

Google Adsense Advertisements

Buy 3 Year Old Domain, Tutorialday.com, SeosmoTools.com @$200

Buy This Ad Space @$50 per Month, Ad Size 300X250 Contact on: hitesh.xc@gmail.com WhatsApp no. 8882538826

Yahoo Advertisements