What are the different privileges required for using views?

Following privileges are required for a different kind of CREATE, REPLACE, DROP, ACCESS, UPDATE etc. of usage of views −

•  CREATE VIEW Privilege − CREATE VIEW privilege is required to create a view. Along with this we must have sufficient privileges, like SELECT, INSERT or UPDATE, for accessing the tables to which the view definition refers.
•  DROP VIEW Privilege − We require DROP VIEW privileges for using OR REPLACE clause, DROP VIEW statement and also for using ALTER VIEW statement.
•  SELECT Privilege − We must have SELECT privileges for selecting from a view.
•  INSERT, DELETE or UPDATE Privileges − Actually for an updateable view to use INSERT, DELETE or UPDATE statements we must have INSERT, DELETE or UPDATE privileges.
•  SHOW VIEW Privilege − If the view definition refers to tables for which we have no privileges then we must have SHOW VIEW privileges along with SELECT privileges.

Lakshmi Srinivas

Published on 22-Feb-2018 09:30:45

• Related Questions & Answers
• What are the privileges required to use triggers?
• What are the limitations of using MySQL views?
• What are the types of Materialized Views?
• What are the modules required for CGI programming in Python?
• What are the prerequisites before starting writing and using MySQL views?
• What are the different steps in using MySQL cursor?
• What are different variations of for loop iterations?
• What are the minimum MySQL user privileges to allow optimize and repair?
• What are the reasons for using EAI?
• What are the different scope values for the JSP action in JSP?
• What are the different computer languages?
• Using djoser in Django for token authentication without views
• What are the different shapes of galaxies?
• What are the different types of psychotherapy?
• What are the different types of DBMS?