Permissions needed to database

• espanolanthony

  SSCarpal Tunnel

  Points: 4204

  More actions

  July 2, 2010 at 8:12 am

  #139620

  What permissions are needed for a user to create stored procedures and triggers. I already have mapped a particular database and also gave him

  db_datareader

  db_datawriter

  db_ddladmin

  so are these rights enough or might need some other to create stored procedures and triggers.

  thanks.

• espanolanthony

  SSCarpal Tunnel

  Points: 4204

  More actions

  July 2, 2010 at 12:30 pm

  #1188388

  8 views and no comments friend? please help me if you know.

• CavyPrincess

  Hall of Fame

  Points: 3336

  More actions

  July 2, 2010 at 2:01 pm

  #1188420

  Per BOL - sysadmin, db_owner, and db_ddladmin will all work.

  http://msdn.microsoft.com/en-us/library/aa258259(SQL.80).aspx

  Cindy