Skip to main content

Views for Security

Learn Views for Security (Views, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction A view can expose only chosen columns and rows of a table. If users get SELECT on the view but no privilege on the table, they see just the allowed slice. SQL SECURITY DEFINER runs the view with the creator's rights.

More lessons in Views