DCL | Data Control Language

Data Control Language

In SQL, there are following two types of DCL commands. As under

• GRANT
• REVOKE

DCL commands are used to control privileges in Database. To perform any operation in the database, link., creating tables, sequences or views, a user needs privileges etc.
Here two types of privileges. As below :

1) System :  This privileges includes permissions for creating session, table etc and all types of other system privileges.

2) Object : This privileges includes permission for any command or query to perform any database tables.

GRANT Command

Grant command used to provide access or privileges on the database objects to the users.

Syntax :

GRANT privilege_list
ON object_name
TO {user_name | PUBLIC | role_name}
[WITH GRANT OPTION];
Example :

GRANT ALL ON Custome01
TO User01;
[WITH GRANT OPTION]

REVOKE Command 

Revoke command used to cancel previously granted or denied permissions.

Syntax :

REVOKE privilege_list
ON object_name
FROM {user_name | PUBLIC | role_name}

Example :

REVOKE UPDATE
ON Customer01
FROM User05;

* * * * * * * * * * * * * * * * *

In Easy Language

Grant - This command used to provide privileges to the user.
Revoke - This command used to take back or cancel privileges from user.

Recommended :

GRANT Command
REVOKE Command