5.SQL Server DCL Commands | GRANT | DENY | REVOKE
DCL Commands:
========================================================
-- DCL commands are used to give/deny/revoke privilages or permissions on Database objects who ever wants (users) to access the DB objects (Tables,views or sprocs ex...)
--Creating Log in
CREATE LOGIN l_sample WITH PASSWORD='1234';
-- Creating User
syntax:
--CREATE USER USER_NAME FOR LOGIN LOG_INNAME
CREATE USER t_USER FOR LOGIN L_SAMPLE;
-- GRANT PERMISSIONS
GRANT is used to give rights/priviliges to users for accessing database objects
GRANT SELECT ON TAB_NAME TO USER (IF YOU PUT PUBLIC IT WILL APPLY TO ALL USERS)
GRANT SELECT ON A TO T_USER
-- DENY
DENY INSERT ON A TO T_USER
-- REVOKE
REVOKE SELECT ON A FROM T_USER
#technology #ssms #sqlserver #dataanalytics #data #database