I have a table
Table_A and a view
View_A that is a select of the contents of
If I deny
Table_A to a user, the user can still use the view
Is there a way that I can force the view to return an error when the user tries to use it?
The real world case here is a database with about 20 tables and hundreds of views. User access is logically tied to the tables so we are hoping to stop folks from using the views based on those tables.