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

In this issue, the editor will bring you about how to allocate users in the SQL Server 2008 database. The article is rich in content and analyzes and describes for you from a professional point of view. I hope you can get something after reading this article.

1. Log in to SqlServer using the administrator account, and create a login in security (as shown below).

two。 Enter the login name, set the password, the default database will select master, the language is also default (as shown in the following figure).

3. Once confirmed, open the database to which you want to assign permissions, and right-click the user node in the security to create a new user (as shown in the following figure).

4. Enter the login name to select the schema and role db_owner. By default, the user has the permission to connect, add, delete, modify and query (as shown in the following figure).

5. Assign a login to the user, which is the new login created in the previous step (as shown in the following figure).

6. OK, OK, OK is done, let's test whether you can access the ShaCDB database using the login name scluguan you just built.

7. Login succeeded

The editor reminds me:

Problems that may be encountered during creation:

Error message: "the database principal has a schema in this database and cannot be deleted. (Microsoft SQL Server, error: 15138)"

Cause of error: sometimes to deploy a database to the server, you will usually back up one locally, upload it to the server and restore it. When you create a new user after restore, you will find that there is already a user in it (if you have not created a user in the local database before, you can ignore this problem), and this user cannot be deleted, which can be solved through the following T-SQL.

Solution: use "your database name" go alter authorization on schema::db_owner to dbo; after manual deletion.

The above is how to allocate users in the SQL Server 2008 database shared by the editor. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

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.