Post reply

exec trigger as sysadmin

  • September 20, 2010 at 7:34 am

    #143462

    I have created a trigger that fires when an object with some name is created, this trigger will deny permisions to all users on the database to alter ot drop just this table but when a user creates this table they could not do it as the trigger is not allowing to.

    So, is there a way i can execute a trigger as sysadmin even if the action that causes the trigger to fire is done by a user.

  • September 20, 2010 at 11:52 am

    #1224250

    Look up "Execute AS" in Books Online. See if that will help you.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply