execute as with synonym

Last Post 30 Jul 2009 07:43 AM by timcronin. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

30 Jul 2009 07:43 AM
This is a good one, I have a stored proc in database A that first deletes some rows from a table in database A. it then does a delete from a synoym that references a table in a different database. We were trying to use a "execute as" with a windows sql account "domain\srvc" that has sysadmin rights. The sp is executed with a sql account with limited security. First can you use a windows\sql account like this, and secondly can you do it with a synonym

Acceptable Use Policy