Security across db's

Last Post 11 Feb 2008 11:14 AM by timcronin. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
timcronin
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?
You are not authorized to post a reply.

Acceptable Use Policy