Editing Data control language (section)

=== Example ===
{{sxhl|2=tsql|
Grant SELECT,INSERT,UPDATE,DELETE on Employees To User1

Revoke INSERT On Employees To User1

Deny Update On Employees to User1
}}
In the first example, GRANT gives privileges to user User1 to do SELECT, INSERT, UPDATE and DELETE on the table named Employees.

In the second example, REVOKE removes User1's privileges to use the INSERT command on the table Employees.

DENY is a specific command. We can conclude that every user has a list of privilege which is denied or granted so command DENY is there to explicitly ban you some privileges on the database objects.: