How to create a new user

How to create a new user

Step 1

To create a new user in your database, go to Enterprise Manager and select the Security folder. Then right click on Login

Then another new window will appear.

Step 2

Under the name, create a user call Demo_admin. As for the authentication choose SQL Server Authentication.

Step 3

Choose Demo as the default database.

Step 4

Click on Server Roles tab and choose System Administrators

Step 5

User can actually assign which database that this particular user has access to in the Database Access tab.

Step 6

For this section we will choose only Demo database and the access roles we will set it to db_owner. Click Ok when done.