Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm dbowner on certain database (my account is on public role on server login but dbowner role on certain databases). Now when I try to add logins from server logins, I can only see sa account and my account. How can I add user to my databases from server logins?

share|improve this question

1 Answer 1

up vote 2 down vote accepted

You need administrator rights to be able to add users to your database. You should be able to add users if you have the "sysadmin" server role checked on your account properties.

There's a fuller description of the various roles here. This is relevant:

The members of securityadmin server role can create and manage server logins and auditing, and read error logs.

So if you can't add the "sysadmin" role, can you add the "securityadmin" role to the account?

share|improve this answer
    
Thanks, but we would like to keep sysadmins separated from dbowners, so that dbowner could add users to their databases. Sysadmin does neccesarily know which users to add to these databases. –  atricapilla Jun 9 '10 at 11:15
    
@jrara - I've updated the answer based on your comment –  ChrisF Jun 9 '10 at 11:25
    
It seems that my must use SecurityAdmin Server Role for those who want add users to databases. –  atricapilla Jun 9 '10 at 11:25

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.