#@data_control_language

[devi1garg]

Data Control Language (DCL)

DCL commands are used to grant and take back authority from any database user.

Here are some commands that come under DCL:

Grant:- SQL Grant command is used to provide access or privileges on the database objects to the users.

Syntax:-

“GRANT privilege_name ON object_name “””TO {user_name | PUBLIC | role_name} [with GRANT option];  

Example:

GRANT SELECT ON employee TO user1

Revo…

View On WordPress