SQL server2008 How to add a single user to a table

Sometimes we have to manage the database to prevent people from misoperation or steal the data, so the small part of this article is to achieve this operation process.

Baidu Experience: jingyan.baidu.com

Tools/Materials

• SQL server2008 Database
• Computer

Baidu Experience: jingyan.baidu.com

Method/Step

2. 1

   1. Open database, enter-security--Login name--New Login

   Steps to read
4. 2

   2. In the General tab, create a login name and set the default database

   Steps to read
6. 3

   3. In the User mapping option, click to tick the database you want to set up, then set the schema, click Confirm, and then complete the action to create the user

   Steps to read
8. 4

   4. This allows us to set permissions on the user table in the test database, select the table--Properties

   Steps to read
10. 5

    5. In the Permissions tab, click Add in order--Browse--Select Object

    Steps to read
12. 6

    6. Click Confirm, we can find the corresponding permissions in the list below, click Confirm to complete the settings of these permissions

    Steps to read
14. 7

    7. Finally, let's check it out.

    steps to read END

SQL server2008 How to add a single user to a table