Thanks much, I'm on Chapter 3 now, reading the whole thing. I'll be better informed when I complete it, and understand it, I'm certain!

Production DB is (RTPOneReporting) DB Owner is 'sa'

Cross database ownership chaining is NOT enabled.

My repository DB is (JHMRReporting) DB Owner is 'dbo'

Cross database ownership chaining is NOT enabled.

My sp, [JHMRReporting].[CallBuyerReportWork],...

• This reply was modified 4 years, 10 months ago by  RichardFRay.
• This reply was modified 4 years, 10 months ago by  RichardFRay.
• This reply was modified 4 years, 10 months ago by  RichardFRay.
• This reply was modified 4 years, 10 months ago by  RichardFRay. Reason: Added information on cross database ownership chaining. (In red)

Excellent reference, thanks!

Yo, Jeff --

So, here's a detail...

When I compile my sp's, in 'my database', with EXECUTE AS OWNER it's fine, but now there are problems in the production db. The sp...

I’m certain there are devils lirking in the details, but that ranks as one of the most succinct and concise answers I have received in 30 years of asking questions...

Thanks for the response.

There’s an enterprise application the db (db 1) for which sits on the server. I don’t want to add or change anything in db1. Therefore, I created...

“Security through obscurity.”

Yep, that’s me. At the longest it’s been another 2”, but i live in Jackson, Wyoming and the beard can collect inconvenient amounts of ice sometimes.

Agreed. I guess I’ve just never seen a SQL object with spaces in the name!