SQL Server Performance Forum – Threads Archive
permission on a table
Hi… If a user does not have permission on a table, but he has permission to a view created on it, will he be able to view the data in table? SURYAyes possible
http://www.mssqlcity.com/Articles/Adm/manage_users_permissions.htm#part_4 —————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka
Views are virtual tables and with permission on view will enable the task to complete.
It is one of the best practice to avoid direct access to table. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
As long as you don’t explicitly DENY the same permission on that table to this user directly, or to any database role to which this user belongs, the permissions on the view should be sufficient.
]]>