Creating a new user on the database server

To create a login for a particular user, perform the following steps.

Start the Microsoft SQL Server Management Studio, connect to the server and open the folder «Security\Logins».

Click the right mouse button and select the item «New Login».

Select the tab «General». In the «Login Name» enter the user name under which you want to connect to the database. Select the authentication option «SQL Server authentication». In the Password field enter the password for this login. Uncheck «User must change password at next login». In the Database field it is necessary to choose the SYSTEM database. In the field Language select language - Russian or leave <Default>.

Click «OK» - a user with the specified username and password will be created. After creation of logins the next task of administrator - to descend to the level of the database and create objects of database users. Open the folder - «Databases\<name of the database SYSTEM>\Security\Users». Click the right mouse button and choose «New User».

At creation of the user you will need to specify:

• User name to which the same rules are applied, as for other objects of SQL Server.
• Login name which will be assigned to the user of this database.
• What roles of a database (Role members) will be assigned to him.
• For the administrator to set a flag - db_owner. The full rights to a database are automatically granted to this role.
• For other roles (user, operator, guest) to set flags db_datareader and db_datawriter. These built-in roles entitle to view and change accordingly any information in a database.

Creating an object of database users: