March 29, 2007 at 10:16 am
I have a user called Guest that is a member of the database role PublicationGrp. This occurs on two separate databases on the same server. Guest is only a user and does not have a login. It is trying to Select against a table in the other database. Publication Group has permissions to this table but Guest still gets an access denied when trying to select. This works fine on our production database but not our development database.
What am I missing?
Any help will be appreciated
March 29, 2007 at 1:38 pm
Make sure you have a "guest" user in both databases. If it's missing, just add him (or her as the case may be 🙂
Carlos
March 29, 2007 at 1:48 pm
Thanks for the reply. I actually figured out what it was. The server needed to be set to cross database chaining.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply