Home Forums SQL Server 2008 Security (SS2K8) Stored procedure 'Execute As Owner' not finding tables RE: Stored procedure 'Execute As Owner' not finding tables
sneumersky
SSCertifiable
Points: 7667
More actions
January 29, 2014 at 1:36 pm
#1684476
EDIT: NM......just read this again and saw ownership chaining has been covered.
We use Execute AS LOGIN to get around some of the issues, but, depending on your environment, that can make things risky as well depending on your situation.