Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
john.burns
Posting Yak Master
100 Posts |
 Posted - 2010-01-14 : 09:34:59
|
| I have a db trigger that logs ddl changes. Proc uses master db(sys.dm_exec_connections) info. I have a user failing to create a table in his 'owned' schema because failing on master perms. required by db trigger.I've attempted to recompile the trigger using impersonation (an account with sysadmin privs)..For some reason I cant't compile trigger with this user. (I am logged in as this same user)message follows:Msg 15151, Level 16, State 1, Procedure backup_objects, Line 25Cannot execute as the user 'domain\adminuser', because it does not exist or you do not have permission.thanks |
|
|
|
|
|
Impersonation