EM remote access

• sql777

  SSC Veteran

  Points: 207

  More actions

  August 29, 2003 at 8:52 pm

  #81953

  What role should I have a user if I want the user to be able to add/delete tables/stored procs, backup/restore etc using EM on a remote machine that has sql2000?

  sounds like system admin? server admin?

  Please keep in mind I want to keep the least amount of permissions/roles as possible.

• mccork

  SSC-Insane

  Points: 22288

  More actions

  August 31, 2003 at 3:12 pm

  #472060

  I suggest that, on a database by database basis, you create a role to do this. Give the role DDL privileges and backup privileges.

  exec sp_addrole 'DDL_And_Backup_Role'

  exec sp_addrolemember 'db_ddladmin' ,'DDL_And_Backup_Role'

  GRANT BACKUP DATABASE TO DDL_And_Backup_Role

  Add your user to this role in the selected databases.

  Cheers,

  - Mark

  
  Cheers,
  - Mark