DCL commands

DCL COMMANDS:

1. GRANT:

It is used to give user access privileges to a database.

Syntax:

GRANT SELECT, UPDATE ON MY TABLE TO SOME_USER, ANOTHER_USER;

2. REVOKE:

GRANT SELECT, UPDATE ON MY TABLE TO SOME USER< ANOTHER_USER;

Syntax:

REVOKE SELECT, UPDATE ON MY TABLE FROM USER!, USER2;

↓