How to create a user's text in sqlserver 2000

Once the hacker obtains webshell, the hacker will know your sqlserver administrator password. If sqlserver is no longer configured with security, the hacker can easily escalate the privilege and create a new system administrator account, then hackers can easily control your computer.

Therefore, you must set security settings. This service is provided on the website of the home-of-your-feet website to help you set security settings.

Next we will return to the topic to briefly introduce how to create a new account.

Go to the Enterprise Manager interface of sqlserver. Two steps are required to create a user.

Step 1: security, login, New Login

Enter the username zz8love, select sqlserver for authentication, and set the bottom line of the password. Do not set the password first (do not prompt for errors or something)

After this is done, the second step is required.

Step 2: Switch to database zz8love user




Select the newly created username zz8love for the login name. Check db_owner (database owner) to add, modify, and delete the database table.

Click OK. If the problem occurs, you can change the name of a duplicate user name during database replacement.