6
I’m trying to use a user other than SA to create new users on an SQL Server 2014 basis, I’ve tried the roles db_accessadmin and db_securityadmin, but they do not give permissions to change other roles.
For example, when I create a user, I want to allow roles db_datareader and db_datawriter for this user, but I do not have permissions.
Anyway, does anyone know how to do that?
3
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.
Browser other questions tagged sql-server sql-server-2014
You are not signed in. Login or sign up in order to post.
You want to insert new users on the server (Server > Security > Logins) or new in a particular database (Server > Databases > Database > Database > Security > Users) in question (note that the user must already exist on the server)?
– Ismael
At the bank level, I want to be able to log in with users other than SA and then create other users and assign roles to them.
– rafakwolf