Explain the working of SQL Privileges?

Category: SQLExplain the working of SQL Privileges?
Editor">Editor Staff asked 2 years ago

 Explain the working of SQL Privileges?

1 Answers
Editor">Editor Staff answered 2 years ago

 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};