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.