Sunny-304011
SSChasing Mays
Points: 645
More actions
August 20, 2007 at 1:24 pm
#69329
I still got error to execute the procedure on select permission deny on the object. Can someone tell me what else I need to do. I have done this on sql server 2005 box with no error. two database chain opened.
Greg Charles
SSC-Forever
Points: 45403
August 20, 2007 at 2:11 pm
#728120
Did you enable cross-database ownership chaining on both databases? Are stored procedure and the tables owned by the same login?
Greg
August 21, 2007 at 5:07 am
#728244
Yes, I did on both database and table owner is DBO. ANy thought?
August 21, 2007 at 9:09 am
#728338
The table is owned by dbo, but is the stored procedure also owned by dbo? The objects in both databases must have the same owner.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply