SQL Server database new user with partial view operation permissions

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.