Home Forums SQL Server 2008 Security (SS2K8) Grant permission to access only 2 tables in a database RE: Grant permission to access only 2 tables in a database

  • March 17, 2015 at 8:32 am

    #1784510

    Sangeeth878787 (3/17/2015)

    Hi Orlando,

    If I need to give access more than 300 users only on two views, these views going to be used in SSRS and Tabular Model. So I need to implement security in Tabular level for more than 300 users, the script you have given is suitable in this case as well?

    Many Thanks

    Sangeeth

    Sure, follow the 3 steps I showed above.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato