September 1, 2010 at 10:00 am
I have setup a database with views that are from another database. The goal is to limit the user to the database with views. How do I setup the user permissions without giving them the right to see the tables in the other database. Right now I gave them connect rights to the original database and select rights in the database with the views.
September 1, 2010 at 10:05 pm
Enable cross database ownership chaining between the 2 databases. Create the views using the same owner/schema as the tables. You should then grant select permission on the views to your users. There should be no need to grant any permissions in the database that contains the actual tables.
September 2, 2010 at 8:05 am
I'm not sure I can do that. If I understand this correctly if I turn it on it is for all databases. We have multiple databases and I don't need it on all of them. I just want to restrict them from viewing the tables in the database with the tables and only allow them to view it through the other database.
September 4, 2010 at 7:03 am
Cross database ownership chaining can be turned on either at the server level or at the database level (have a read of http://technet.microsoft.com/en-us/library/ms188694.aspx). So, your concern about having to allow this at server level is not warranted.
September 4, 2010 at 7:05 pm
I'll check that out. Thanks.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply