Explain the working of SQL Privileges?

Question

Can anyone help me with clear syntax..

Jay Krishna Reddy · Answer

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. to provide database access to users other than the administrator. GRANT privilege_name ON object_name TO {user_name| PUBLIC |role_name} [ WITH GRANT OPTION ]; Hope this helps you..

Pistle Potter · Answer

Privileges defines the access rights provided to a user on a database objects. There are two types of privileges: (a) System Privileges: This indicate user to CREATE, ALTER, or " "DROP database elements. (b) Object Privileges: This allows user to EXECUTE, SELECT, INSERT, or DELETE data from database objects to which the privileges apply. • Roles are the collection of privileges or access rights. When there are many users in a database it becomes difficult to grant or revoke privileges to the users. • So, if we define roles we can automatically grant/revoke privileges. Hope this will help. Best Regards

Explain the working of SQL Privileges?

Answers (2)