Last answered:

07 Nov 2022

Posted on:

04 Nov 2022


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)
Posted on:

07 Nov 2022


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.

Submit an answer