Explain DCL command

Explain DCL command.

- The DCL commands are used in a multiple user database environment to enforce database security.
- There are two types of DCL commands. They are GRANT and REVOKE.
- Only Database Administrator's or owner's of the database object can provide/remove privileges on a database object.

GRANT
This command is used to provide access or privileges on the database objects to the users.

REVOKE
This command removes the user access rights or privileges to the database objects.
What is TCL command?
TCL - Transaction Control: statements used to manage the changes made by DML statements. It allows statements to be grouped together into logical transactions....
Differences between GRANT and REVOKE command
By using the GRANT command you can grant an system level previledge or role to another user.....
Explain ROLLBACK and COMMIT command
The transactions like update, insert or delete can be undone with the help of rollback command. This is helpful when an introduced during your work. ..
Post your comment

Related Content

Follow us

▲