SQL SECURITY INVOKER clause in MySql

The SQL SECURITY INVOKER clause is used to control access to data, generally in a view. Using the SQL SECURITY INVOKER clause will enforce rules that the user must have permissions to also see the underlying data. Creating view using the SQL SECURITY INVOKER clause. CREATE SQL SECURITY INVOKER VIEW system_users AS SELECT host,USER,password FROM […]
Continue reading…

Enjoyed this post? Share it!