2

If I run this query, does that give sysadmin rights to the database the query is being run on or to all databases?

exec sp_addsrvrolemember N'username', sysadmin

Joril
  • 19,961
  • 13
  • 71
  • 88
Nick Strupat
  • 4,928
  • 4
  • 44
  • 56

1 Answers1

2

sysadmin is SQL Server level admin so it would be all databases with no restrictions at all

You want db_owner in the database for one database

gbn
  • 422,506
  • 82
  • 585
  • 676
  • Ah ok. Thank you! Would you happen to know the stored procedure to remove sysadmin rights from a user? – Nick Strupat Apr 13 '11 at 19:17
  • @nick: sp_dropsrvrolemember http://msdn.microsoft.com/en-us/library/ms186270.aspx – gbn Apr 13 '11 at 19:20
  • Thanks again! I've been trying to figure out how to give db_owner to my user but I figured it might be a quick solution to query your database of knowledge once more. – Nick Strupat Apr 13 '11 at 19:47
  • @nick: sp_addrolemember in the database http://msdn.microsoft.com/en-us/library/ms187750.aspx `exec sp_addrolemember 'db_owner', 'username'` – gbn Apr 13 '11 at 19:49
  • That is actually one of the commands I tried. It gives me the error: 'db_owner' is not a fixed server role. – Nick Strupat Apr 13 '11 at 19:51
  • @nick: sorry, copy/paste fubar. fixed comment. – gbn Apr 13 '11 at 19:53