SQL Commands Part 3(Grant and Revoke). Session 10

• DCL (Data Control Language) Deal with the rights, permissions, and other controls of the database system
GRANT - We provide access or privileges on the database objects to the users.
REVOKE - with this command we can take back permission from users.
 create login sunny with password='1234' -- login
 create user pandita for login sunny -- user
 grant insert on student to pandita -- proving access to user pandita
 grant select, insert, update on student to pandita -- multiple access
 revoke insert on student to pandita
 revoke select, insert, update on student to pandita

[@nishapandita]

One of the best videos on Grant and Revoke. Understood all the concepts clearly.

[@AzharudeenHithayathullah]

Really helpful. Please keep doing it.

[@yogeshpandita7828]

Salute sir. I have no words to say.
Your teaching is awesome ❤
Take care sir ji

[@sunnypandita1498]

Thanks a ton

[@nishapathania146]

Very well explained

[@vishalmukund96]

Right

[@RohitThakur-xu5wd]

Can you please make one video on CTE and one on window functions to understand logic and syntax.....with brief