Home Forums SQL Server 2008 Security (SS2K8) SSRS Column Hide based on User Login. RE: SSRS Column Hide based on User Login.

  • September 24, 2013 at 10:40 am

    #1652833

    Andreas.Wolter (9/24/2013)

    Ok

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

    That's why I went with the roles-to-objects approach.

    Thanks

    John.