I have a stored procedure owned by DBO on a Database that is accessing some system views on Master. Those views are owned by SYS, so in this case, execution privileges given on DB1 to the SP Owned by DBO do not take advantage from the cross database chaining.
How can I have users able to execute such SP on DB1 without granting them explicity permissions on the system views that are on Master?
Thanks in advance,
View Complete Post