Sunday 13 March 2016

SQL SERVER -- DCL Commands -- Part-8

SQL SERVER -- DCL Commands -- Part-8

DCL Commands:-
                                               DCL Stands for Data Control Language.
DCL commands are used to enforce database security in a multiple user database environment. Following are the DCL Commands available.
                                                               1. GRANT
                                                               2. REVOKE

GRANT – Grant Command is used to provide access or privileges on the database objects to the users.

REVOKE– REVOKE Command is used to remove access or privileges on the database objects to the users.




No comments:

Post a Comment