Data Control Language (DCL) is used to control privileges in Database. To perform any operation in the database, such as for creating tables, sequences or views, a user needs privileges. Privileges are of two types,
System: This includes permissions for creating session, table, etc and all types of other system privileges.
Object: This includes permissions for any command or query to perform any operation on the database tables.
In DCL we have two commands,
GRANT: Used to provide any user access privileges or other privileges for the database.
Syntax:-
GRANT SELECT, UPDATE ON MY_TABLE TO SOME_USER, ANOTHER_USER;
REVOKE: Used to take back permissions from any user.
Syntax:-
REVOKE SELECT, UPDATE ON MY_TABLE FROM USER1, USER2;