Home / server / Questions / 149592
Accepted
atricapilla
Asked: 2010-06-10 03:06:07 +0800 CST

SQL Server 2008: how to add logins to database

  • 772

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?

sql-server logging sql-server-2008 sql

1 Answers

  1. Best Answer

    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?

    • 2