Monday , December 10 2018
Home / DataBase / SQL SERVER / DATA CONTROL LANGUAGE(DCL) In Sql Server

DATA CONTROL LANGUAGE(DCL) In Sql Server

DATA CONTROL LANGUAGE(DCL)  In Sql Server

DATA CONTROL LANGUAGE: By Using DCL We Can control the data between different user accounts. DCL Commands Includes

  1. GRANT Statement

      2.REVOKE Statement

 

1.Grant Statement: By Using Grant Statement we can  grant the permissions (INSERT, SELECT, UPDATE, DELETE) on a specific table to different user accounts.

2.Revoke Statement: By Using Grant Statement we can revoke the permissions (INSERT, SELECT, UPDATE, DELETE) on a specific table from different user accounts.

 

 

 

Print Friendly, PDF & Email

Give us your valuable feedback

comments

About Samba

Check Also

sql server backup script

Backup all databases in SQL Instance with one script

Backup: A copy of SQL Server data that can be used to restore and recover the …