johntam (9/24/2013)
Andreas.Wolter (9/24/2013)
OkI guess instead of Tables you want to give permissions on the views that you mentioned.
You might just as well put them into 2 different schemas.. keeps the permissions on schema-level - and just 1-2 permissions instead of one per object and grantee
True, that works. However, then you need to develop views for many tables if they reside in the MANAGERS schema. Just looking at the object counts. also, there are many who don't like to work with schemas, and prefer to use only dbo.
well.. those then should learn about the advantages of schemas and why it's (usually) bad practice to just use dbo. SQL 2000 is over...
Andreas
---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com