Adding multiple users to an enterprise database in one go

[AhmadSALEH1]

Hi All,

I couldn’t figure out how to add multiple users to an Enterprise database in one go.

Please consider the following situation:

1 ) I have an  enterprise database named “ Test02”

2) Then I try to add multiple users to it in one go, these users are stored before in the SQL server.

3) Now the problem that I can’t add them all to the database and I need to add each user alone and set a password to it.

Is there any method to see all users in the SQL server and add (all or some ) of them to the database.

Many thanks,

Ahmad