Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to build new users and related databases in sqlserver". Friends who are interested may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "how to build new users and related databases in sqlserver".

We often need to set up authorized users on the database, who can only operate on a specific database (for example, the user can only read, write, etc.), so how should we set it on sqlserver? The following steps are a little long, as long as you follow the settings step by step

Methods / steps

If you do not enable sqlserver authentication, first enter the windowns identity management system and activate it.

Attributes-right-click-Security-enable

Then you need to restart (in the right-click summary point)

Then add a new login name to the security-login name

Enter the user name and password; the password is best enabled to enforce the password policy.

Then find the security-right-create-user in the database where you want to activate user permissions.

Enter the user name just now, and then check the user architecture and role. Here, check db-owner (with full permissions)

Finally, use this account to link

If you click on another database, it will prompt you that you do not have permission

At this point, I believe you have a deeper understanding of "how to build new users and related databases in sqlserver". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.