0 votes
in Sql by
Explain the working of SQL Privileges?

1 Answer

0 votes
by

SQL GRANT and REVOKE commands are used to implement privileges in SQL multiple user environments. The administrator of the database can grant or revoke privileges to or from users of database objects by using commands like SELECT, INSERT, UPDATE, DELETE, ALL, etc.

GRANT Command: This command is used to provide database access to users other than the administrator.

Syntax:

GRANT privilege_name

 ON object_name

 TO {user_name|PUBLIC|role_name}

 [WITH GRANT OPTION];

In the above syntax, the GRANT option indicates that the user can grant access to another user too.

REVOKE command: This command is used to provide database deny or remove access to database objects.

Syntax:

REVOKE privilege_name

 ON object_name

 FROM {user_name|PUBLIC|role_name};

Related questions

0 votes
asked Jan 21 in Oracle by rajeshsharma
0 votes
asked Jul 12, 2020 in Sql by Robindeniel
...