biinsight.com
How to manage the user access rights to see database views but not source tables using T-SQL
Problem: There is a group of users that are not intended to have direct read access to the database tables. There are some predefined database views that the users should be able to see the data through those views. In our case, the users shouldn’t be able to even see the tables in SSMS or … Continue reading How to manage the user access rights to see database views but not source tables using T-SQL