permission on a table | SQL Server Performance Forums

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? SURYA
yes possible —————————————-
Cast your vote

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
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.