Data Control Language

Data Control Language (DCL) Commands (GRANT and REVOKE), DCL Operations (Grant privileges to a users and Revoke (remove) privileges from Users) and Database Administration.
Post Reply
manoj
Posts: 87
Joined: Fri Nov 23, 2018 5:29 am

Data Control Language

Post by manoj » Wed Nov 28, 2018 11:56 am

What is the Data Control Language and give some examples?

AyubHussain
Posts: 138
Joined: Fri Nov 23, 2018 2:48 am

Re: Data Control Language

Post by AyubHussain » Wed Nov 28, 2018 11:57 am

Data Control Language :

Data Control Language (DCL) commands are used to control the visibility of the data in the database like revoke access permission for using data in the database.

Data Control Language (DCL) commands:

1.COMMIT to permanently save.
2.ROLLBACK to undo the change.
3.SAVEPOINT to save temporarily.

Post Reply

Return to “SQL - Data Control Language”