DENY statement
you said in this lesson there's only two statement in dcl and it's there I guess , am I right ?
1 answers ( 0 marked as helpful)
Hi Mohamed!
Thanks for reaching out.
There are two DCL statements - GRANT and REVOKE.
GRANTcommand is specifically used to provide privileges to database objects for a user. This command also allows users to grant permissions to other users too.
REVOKEcommand withdraw user privileges on database objects if any granted. It does operations opposite to the GRANT command. When a privilege is revoked from a particular user, then the privileges
granted to all other users by the first one will be revoked.
Hope this helps.
Best,
Tsvetelin
Submit an answer
