what is dcl? and why to use with example

Posted by Venky.Net under Sql Server on 5/1/2012 | Points: 10 | Views : 915 | Status : [Member] | Replies : 2
hi
i dont know about dcl commands.so i want some basic infromation about dcl and example




Responses

Posted by: Oswaldlily on: 5/2/2012 [Member] Starter | Points: 25

Up
0
Down
Data Control Language (DCL) statements.Data Control Language is used for the control of data. That is a user can access any data based on the priveleges given to him. This is done through DATA CONTROL LANGUAGE. Some of the DCL Commands are:

GRANT - gives user's access privileges to database
REVOKE - withdraw access privileges given with the GRANT command


Venky.Net, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Muhsinathk on: 9/5/2012 [Member] Bronze | Points: 25

Up
0
Down
The Data Control Language (DCL) is a subset of the Structured Query Lanaguge (SQL) that allows database administrators to configure security access to relational databases.
DCL is the simplest of the SQL subsets, as it consists of only three commands: GRANT, REVOKE, and DENY. Combined, these three commands provide administrators with the flexibility to set and remove database permissions in an extremely granular fashion.
GRANT [privilege]
ON [object]
TO [user]
[WITH GRANT OPTION]

REVOKE [GRANT OPTION FOR] [permission]
ON [object]
FROM [user]
[CASCADE]

DENY [permission]
ON [object]
TO [user]


Venky.Net, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response