sql server role

• vs.satheesh

  SSCrazy

  Points: 2392

  More actions

  June 20, 2012 at 11:32 pm

  #98240

  Hi All

  I create a Role and Users in sql server following manner.

  Step 1 :

  I created a role name call "DEVELOER"

  Step 2:

  Under this role I created a two users.I given Select update and delete insert permission this "Develper" role.

  Step 3:

  I given Stored Procedure Exection and Creaton Permission also..

  Above point all the condition working file..

  Buty my question is in this user following think not woking

  1) DML and DDL Trigger is not woking.Please Give me a command?

  Thank You

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  June 21, 2012 at 2:29 am

  #1503816

  Edit

  Duplicate post http://www.sqlservercentral.com/Forums/Topic1319084-359-1.aspx