sql server 2016 database newuser creation option not available

Do you have the permissions to create new logins, e.g. because you are member of the SysAdmin or SecurityAdmin role?

Hi @Bala G ,

1.Firstly please make sure you have the Alter Any User Permission on the database;

--Execute code as next to check what permissions your account have:  
--Instance Level  
SELECT * FROM fn_my_permissions(NULL, 'SERVER');   

--Database Level  
SELECT * FROM fn_my_permissions ('DBA', 'DATABASE');  

2.Please try to create a new user with t_sql: create-user-transact-sql

3.Download the latest SSMS to take your test: release-notes-ssms

Note:
A user is a database level security principal. Logins must be mapped to a database user to connect to a database. A login can be mapped to different databases as different users but can only be mapped as one user in each database. In a partially contained database, a user can be created that does not have a login. For more information about contained database users, see CREATE USER (Transact-SQL). If the guest user in a database is enabled, a login that is not mapped to a database user can enter the database as the guest user.

IMPORTANT! The guest user is ordinarily disabled. Do not enable the guest user unless it is necessary.

As a security principal, permissions can be granted to users. The scope of a user is the database. To connect to a specific database on the instance of SQL Server, a login must be mapped to a database user. Permissions inside the database are granted and denied to the database user, not the login.

BR,
Mia

If the answer is helpful, please click "Accept Answer" and upvote it.

Hi OlafHelper-2800,

Thanks for your reply , i dont know how to give permissions and new user creation option not available for the database 'master' as well as other DB created by me. please let me know the how to enable the option.

anyone tell me the solution for my issue