User who has permission to create another SQL Server user

6

I'm trying to use a user other than SA to create new users on a SQL Server 2014 base, I've tried the db_accessadmin and db_securityadmin roles yet, but they do not permissions to change other roles.

For example, when I create a user, I want to allow the db_datareader and db_datawriter roles for this user, but I do not have permissions.

Anyway, does anyone know how to do this?

    
asked by anonymous 24.01.2017 / 11:46

1 answer

3

In order to create a login you need one of the following permissions ALTER ANY LOGIN or ALTER LOGIN To create the user you will need the following permission ALTER ANY USER

The login is for it to connect to the server while the user is to allow the login to connect to the Database.

    
24.01.2017 / 12:52