I have a table on which a view is created. I need to perform Insert, Select, Update & Delete from the View. On the Table, I should not be able to do any those operations (Insert, Select, Update & Delete). Basically Revoke (Insert, Select, Update & Delete ) Permission from Table and from the view of based on that table i should be able to perform Insert, Select, Update & Delete operations.
Yeah, I am simulating RLS similar to Oracle VPD and from session variable i am able to create a view to use the session variable for data isolation. In Oracle VPD, The policies are applied to Tables so any one who logs in will only see his data. In MySQL if the user queries the Table instead on View he willl see all the records which i am trying to avoid.