SQL Server------sqlserver2008r2 new user and set access permissions for the table

In the project docking, sometimes in the system security considerations, we need to set the database access rights, this time, we can add a user, and then set the user's access rights, the following steps:

1, New Login Object

2, click User Mappings

3, after the operation, click OK, there may be error interface, no tube, then the new user has appeared in the login name

4, choose the database Zngkpt, and then select the corresponding table Cms_release, right-click Properties----Search,

5, click Search, the Search box appears, and then enter the user name just now, click Check Name

6, then click on the user name test, then select the appropriate permissions

7, click OK, logout SQL Server, and then log in with test, the interface is as follows, click another database to display no access

8, when deleting the user, pay attention to the deletion sequence, first delete the user name in the database, and then delete the user name in the server, if the deletion prompts you the user is logged in, you can restart the SQL Server servers to resolve this.

SQL Server------sqlserver2008r2 new user and set access permissions for the table