How to give permissions to create and execute triggers

• VIJAYA SATISH KUMAR BODAPATI

  SSC-Addicted

  Points: 437

  More actions

  November 14, 2008 at 11:16 am

  #201349

  Hi,

  I created a database user and assigned required permissions. Then I created a database with the new user and trying create and execute ddl triggers. But it was syaing that

  "Msg 2104, Level 14, State 1, Procedure MyDDL_trig, Line 12

  Cannot create the trigger 'MyDDL_trig', because you do not have permission."

  My question is how can I give permissions to create and execute triggers to the new user on new database

  I have another question... is there any possibility to assign all the powers of "sa" to a new user at one shot ? (like in oracle - grant dba to )

  Thanks in advance

  Satish

• Grinja

  Hall of Fame

  Points: 3590

  More actions

  November 17, 2008 at 4:48 am

  #899245

  I would guess that the user who created the DB would have the permission to do this ...

  Perhaps you can add the login for that specific DB to db_Owner role?