Tuesday , June 19 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

Find all rows count and columns count in single database in sql server

In General for any database it contains lot of tables, if we want to find …

%d bloggers like this: