you said in this lesson there's only two statement in dcl and it's there I guess , am I right ?

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

Follow this topic

Muhammed K.Fouad

Last answered:

07 Nov 2022

Posted on:

04 Nov 2022

DENY statement

in SQL / Data control language (DCL)

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

07 Nov 2022

DENY statement

Submit an answer

related questions