permissions on procedure that access another database

[mbair]

If I execute a stored procedure that accesses a table on another database. I get an error that I have no permissions on the other database. Is there a way to run the procedure without the permission?

 

[philhege]

Not if the logged-in or impersonated user doesn't have the rights to the DB. What's the environment?

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'm not as think as you confused I am.
-----------
Flabbergasted (a.): Amazed at how much weight one has gained.
-----------
Oyster (n.): One who sprinkles their conversation with Yiddish expressions.

 

[mrdenny]

If you have cross database chaining off then all users that will be running the procedure will need rights to the other database. If you cross database chaining on then you shouldn't need to grant these rights.

If you are using Windows Auth then add all the users to a group and grant the group rights in both databases. This way you don't need to grant induvidual user rights within the database, you can take care of it via the group.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief