Scribd
Upload
22 views2 pages

DCL Command

DCL command in DBMS.

Uploaded by

indrabhan919
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
22 views2 pages

DCL Command

DCL command in DBMS.

Uploaded by

indrabhan919
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Experiment No- 06

AIM: TO PERFORM THE DCL (Data Control Language) commands.

DCL: DCL stands for data control language. DCL commands are primarily used to implement
access control on the data store in the database. The administrator can be Implement DCL
command to add or remove data permission on a specific user that database when required.

GRANT Command: This command allow the administrator to provide a particular privilege or
permission over a database object.

Syntax: GRANT privilege name ON object name TO user;

NAME- INDRA BHAN VERMA ROLL NO- 2204220130025


REVOKE Command: This command enables the database administrator to remove the
previously provided privilege or permissions from a user over a database.

Syntax: REVOKE privilege name ON object name FROM user;

NAME- INDRA BHAN VERMA ROLL NO- 2204220130025

You might also like