We discuss SQL Data Control Language (DCL) and practically go through GRANT, REVOKE and DENY statements in SQL Server 2019. We see how to use GRANT statements to give a user and role privileges. We also use REVOKE statements to remove a previously granted permission and finally use DENY statement to prevent user access to a database object. We also discuss the differences between REVOKE and DENY controls in SQL Server.
--LINK TO SQL QUERY--
https://github.com/AllThingsDataWithAngelina/SQL-Server/blob/main/Data_Control_Language_DCL.sql
--LINKS TO PARTS OF THIS VIDEO SERIES--
Learn SQL with Microsoft SQL Server | Installing SQL Server 2019 and Restoring Database | Part 1: https://youtu.be/NLhu4QvFPsU
Learn SQL with Microsoft SQL Server | Data Definition Language | Part 2: https://youtu.be/0xINwDcFLSk
Learn SQL with Microsoft SQL Server | Data Manipulation Language | Part 3: https://youtu.be/EMAhw6nM3wk
HAPPY WITH THE CONTENT?
SHARE AND SUBSCRIBE NOW! CLICK HERE - https://www.youtube.com/channel/UC0HS0EUIgPVrqIbde-2f1GQ
OR HERE - https://bit.ly/angelinafrimpong
#SQL #LearnSQL #SSMS
