grant dba role

• bruce_reid

  SSCrazy

  Points: 2419

  More actions

  May 12, 2003 at 9:12 am

  #106076

  I have a server xxx with some 12 databases.I would like to grant the role of dba on entire server(means for all the 12 databases and to to give the permission to start sql server agent) to an user yyyy.Whats the best way of doing it enterprise manager.

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  May 12, 2003 at 9:20 am

  #456859

  Hi,

  well in EM goto Security -> Logins.

  Select your user -> right-click -> properties.

  Select 'Database Access' Tab.

  Check 'Permit' and 'db_owner' for each DB.

  It's a stupid activity , if someone knows a smarter way in EM, please let me know

  Cheers,

  Frank

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]