Creating a new user on the database server

Print Previous page Top page Next page

To create a login for a user with database administrator rights, you need to 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».

 

_bm3762

 

Choose the «General» bookmark. In the field «Login Name», enter the username under which you want to connect to the database. Select the  «SQL Server authentication» authorization option. In the Password field, set the password for this login. Uncheck the box «User must change password at next login». In the Database field, select the SYSTEM database. In the Language field, select the language - Russian or leave <Default>.

 

_bm3763

 

Click «OK» button - 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» item.

 

_bm3764

 

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:

_bm3765