SQL Server database new user with partial view operation permissions

First log in to the SA user with the highest privileges

After logging in security Select Login name right click Select New Login

Pop-up new login interface, fill in the user name and select the login method, select the page interface on the left to select the server role, user mapping, security objects and state settings respectively

Here we set up to open the database needs to be set in "User mapping", tick the corresponding database, you can use the user action to view the corresponding database. Click OK to complete the creation.

Log in to SQL with this username, and you can see that our current user has the database we chose to view, but there are no tables or views. That would require us to set the table or view that the user can view.

Set up a new user-viewable table or view, need to return to our SA user, find the table or view to open, right click to select the Last property, pop up the Table Properties window, select permissions on the Select page to open the Rights management interface

Click the Search button to open the "Select User or Role" window, click the Browse pop-up Find object window

、

Select the target user to open our table Click OK back to the Table Properties window

Set the appropriate permissions click OK

At this point, we will be able to see the tables we have set up for our new users.

SQL Server database new user with partial view operation permissions