SQL Server Performance Forum – Threads Archive
permission on a tableHi… 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
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.