Re: Application Role & 2nd Database
From: Jeff Price (price.9_at_osu.edu)
Date: Fri, 13 Feb 2004 09:38:18 -0500
Thanks! That did the trick.
Do we need to be concerned with the existence of the "Guest" account?
"Dan Guzman" <email@example.com> wrote in message
> Since an application role is only known in a single database, you need to
> enable the 'guest' user in the other database so you have a security
> in the other database. No guest user permissions need to be granted. For
> Use MyOtherDatabase
> EXEC sp_adduser 'guest'
> Also, you don't need to enable cross-database chaining at the server
> Your can specify it at the database level for only the databases that need
> this option turned on:
> EXEC sp_dboption 'MyDatabase, 'db chaining', 'TRUE'
> EXEC sp_dboption 'MyOtherDatabase, 'db chaining', 'TRUE'
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Jeff Price" <firstname.lastname@example.org> wrote in message
> > Correction........
> > I did not get the Application role to work across Databases. I continue
> > receive the error "Server user 'price_9' is not a valid user in database
> > 'FCoB_Contacts'."
> > I've tried both
> > EXEC sp_configure 'Cross DB Ownership Chaining', '1';RECONFIGURE
> > and
> > EXEC sp_configure 'Cross DB Ownership Chaining', '0';RECONFIGURE with
> > EXEC sp_dboption 'FCoB_Contacts', 'db chaining', 'TRUE'
> > Both DBs are owned by the same account.
> > Drat!
> > "Jeff Price" <email@example.com> wrote in message
> > news:Ohj0lGD8DHA.360@TK2MSFTNGP12.phx.gbl...
> > > I'm trying to use application roles for the 1st time and have a
> > > Most of the select statements I use reference tables in a separate
> > database.
> > > After reading the BOL I find that this only works through the GUEST
> > account.
> > > Drat!
> > >
> > > Any suggestions to fix this? I'm considering setting up views in the
> > local
> > > DB, but this will involve changing the code and creating the views and
> > > still don't know if it will work.
> > > --
> > > Jeffrey R. Price
> > > Database Manager
> > > Computing & Communication Services
> > > Max M. Fisher College of Business
> > > The Ohio State University
> > > 320F Mason Hall
> > > 250 W. Woodruff Avenue
> > > Columbus, OH 43210-1309
> > >
> > >