Grant DB Roles and Server Roles

• sbalaven

  Ten Centuries

  Points: 1127

  More actions

  January 8, 2008 at 3:19 am

  #69690

  Hi,

  I want to grant access to the individual user to create and Execute DTS packages in SQL 2000.

  Which Server roles and Database roles granted for this users. Please let me know.

  Regards,

  S.Balavenkatesh

• Chandra Sekhara Vyas Dhara

  SSChampion

  Points: 10207

  More actions

  January 8, 2008 at 4:58 am

  #765650

  Is it in SQL Server 2000 or 2005?

• sbalaven

  Ten Centuries

  Points: 1127

  More actions

  January 8, 2008 at 5:03 am

  #765653

  Both SQL 2000 and SQL 2005