SQL Server creates users and assigns permissions

SQL Server creates users and assigns permissions

On the server side, create the database and create the users and permissions:

1. Create User:

Open SQL Server Manager with Admin user, security-login name, right-click New user.
Add: Login name: user1, and SQL Server identity password. Remove the "Enforce password policy".
Select the default database and the default language is Simplified Chinese.

On the Server Roles page: select public.
On the User Mapping page: Select database: such as data.
On the Status page: Select Grant, Enabled. Click OK. User creation has been completed with only the primary permission.

2, the allocation of access rights to establish a database:

With the administrator user, make the database data, attributes--permissions, for User1 users, assign Select, add, modify, delete, execute permissions.

8 Permissions: Connect, select, insert, change, UPDATE, delete, execute, view database status.

3. New user test:

Disconnect, log in with User1 user, test Add, modify, delete function is normal.

SQL Server creates users and assigns permissions