November 28, 2012 at 8:51 am
I have a view that users need to use in db1 that the users have db_datareader. The view points to table in another database db2 that the users have no permissions to. How do I grant them access to the view
error:
The server principal "test" is not able to access the database "Db2" under the current security context.
November 28, 2012 at 9:06 am
Have a read about cross database ownership chaining and post back if there's anything you still don't understand.
John
November 28, 2012 at 9:14 am
I should mention that the db2 database is using sql server replication and it is a subscribing database. Would cross-chaining affect replication?
November 28, 2012 at 9:19 am
I don't imagine so, but I wouldn't swear to it. Somebody else may have an answer.
John
November 28, 2012 at 12:46 pm
I am still getting the error after enabling db cross chaining
November 28, 2012 at 1:32 pm
To help you with this we're going to need more information. What is DB2, is that a database on the server or is that your linked server? What is test? I assume that's either an account or a database.
Is the view trying to look up information in a linked server or another database on the same server? What are the schemas (and schema owners if not DBO) of these objects?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply