SQL DML Commands

Advertisements

TCL Command in SQL Create Table in SQL

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

Syntax

	

To allow user to create table

Syntax

	
grant to create table to username;

To give all privilage to user

Syntax

	
grant sysdba to username;

To take back permision

Syntax

	
revoke create table from username

TCL Command in SQL Create Table in SQL

Advertisements

Buy This Ad Space @$20 per Month, Ad Size 600X200 Contact on: hitesh.xc@gmail.com or 9999595223

Pure VPN Privide Lowest Price VPN Just @ $1.65. Per Month with Non Detected IP Lowest Price Non Detected IP VPN

Magenet is best Adsense Alternative here we earn $2 for single link, Here we get links ads. Magenet

Download Projects

Google Advertisements


Buy Websites 9999595223

Buy College Projects with Documentation Contact on whatsapp 9999595223. Contact on: hitesh.xc@gmail.com or 9999595223 Try this Keyword C++ Programs

Advertisements