Security across db's

Last Post 11 Feb 2008 11:14 AM by timcronin. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

11 Feb 2008 11:14 AM
I have a db that has an app which calls a stored procedure in database A. It calls a stored procedure (with some id's passed to it) in database B which has some updates and deletes. We are using Windows/SQl Authentication. We have a role defined in each database with rights to the SP's and windows groups as logins assingned to the roles in Database A and B. Will the deletes and updates work on Database B if the user does not have specific right to the tables?

Acceptable Use Policy