MS SQL Server - grant the privilege of create user to other users

Author

grant the privilege of create user to other users

hongo32

2006-03-08, 11:23 am

Hi, in sql server 2000 for create a login I use the command sp_addlogin
but if i connect to sql server with a user that not is 'sa' or trusted
connection and execute addlogin the server shows that i don't have
permisions.

how can i do for a user diferent to sa have the privilege to create
users?

thanks.

Daniel Jameson

2006-03-08, 8:23 pm

Hi,

make your login a member of the fixed server role "securityadmin"
In Enterprise Manager double click a login (in the Security folder of a
server) and click the "Server Roles" tab to assign fixed server roles.
--
Thank you,

Daniel Jameson
SQL Server DBA
Children's Oncology Group
www. childrensoncologygro
up.org

"hongo32" <hongo32es@yahoo.com> wrote in message
news:1141835445.230660.269690@i40g2000cwc.googlegroups.com...
> Hi, in sql server 2000 for create a login I use the command sp_addlogin
> but if i connect to sql server with a user that not is 'sa' or trusted
> connection and execute addlogin the server shows that i don't have
> permisions.
>
> how can i do for a user diferent to sa have the privilege to create
> users?
>
> thanks.
>

Sponsored Links