Mud: Use Navicat for SQL Server to create a database, grant users and permissions

This article was sponsored by 51cto.com and first launched in the dark world.

To be honest with SQLServer2005, I am not very familiar with it. I will share my research results this afternoon.

Use the Navicat for SQL Server tool to manage databases. This involves the following content:

1. Create a database

2. Create a user

3. Grant Permissions

I,Create Database

Start Navicat for SQL Server and click "Connect", as shown in:

650) this. width = 650; "style =" background-image: none; margin: 0px; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; "title =" clip_image001 "border =" 0 "alt =" clip_image001 "src =" http://www.bkjia.com/uploads/allimg/131228/22261529A-0.png "width =" 582 "height =" 256 "/>

650) this. width = 650; "style =" background-image: none; margin: 0px; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; "title =" clip_image002 "border =" 0 "alt =" clip_image002 "src =" http://www.bkjia.com/uploads/allimg/131228/222615N56-1.png "width =" 523 "height =" 589 "/>

In the displayed dialog box, enter relevant information. Note the following in "host name. You can enter the IP address and port number. You can also enter the IP address directly. The IP address and port are the port number modified by SQLServer. As shown in:

650) this. width = 650; "style =" background-image: none; margin: 0px; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; "title =" clip_image003 "border =" 0 "alt =" clip_image003 "src =" http://www.bkjia.com/uploads/allimg/131228/2226155a1-2.png "width =" 520 "height =" 284 "/>

After entering the relevant information correctly, we can connect to the database normally ., As shown in:

650) this. width = 650; "style =" background-image: none; margin: 0px; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; "title =" clip_image004 "border =" 0 "alt =" clip_image004 "src =" http://www.bkjia.com/uploads/allimg/131228/2226156304-3.png "width =" 309 "height =" 357 "/>

Next, we will start creating a database. Right-click "create database", as shown in:

650) this. width = 650; "style =" background-image: none; margin: 0px; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; "title =" clip_image005 "border =" 0 "alt =" clip_image005 "src =" http://www.bkjia.com/uploads/allimg/131228/2226156054-4.png "width =" 332 "height =" 539 "/>

In the "Database Name" option, enter the name of the database we created, as shown in:

650) this. width = 650; "style =" background-image: none; margin: 0px; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; "title =" clip_image006 "border =" 0 "alt =" clip_image006 "src =" http://www.bkjia.com/uploads/allimg/131228/2226155316-5.png "width =" 497 "height =" 335 "/>

Under the "file" option, we can change the location where the database is stored, and then click "save" to create a new database. For example:

650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131228/2226153151-6.png "width =" 666 "height =" 458 "/>

650) this. width = 650; "style =" background-image: none; border-bottom: 0px; border-left: 0px; border-top: 0px; border-right: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; "title =" clip_image001 [1] "border =" 0 "alt =" clip_image001 [1] "src =" http://www.bkjia.com/uploads/allimg/131228/22261520B-7.png "height =" 449 "/>

II,Create user

After the database is created, we need to create a new user. Click the "user" option and select "user" in the level-2 menu, as shown in:

650) this. width = 650; "style =" background-image: none; margin: 0px; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; "title =" clip_image010 "border =" 0 "alt =" clip_image010 "src =" http://img1.51cto.com/attachment/201306/25/526870_1372139278Vuc9.png "width =" 290 "height =" 289 "/>

On the new page, we can see the "create user" button, and right-click the button to bring up the "create user" button, as shown in:

650) this. width = 650; "style =" background-image: none; margin: 0px; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; "title =" clip_image011 "border =" 0 "alt =" clip_image011 "src =" http://www.bkjia.com/uploads/allimg/131228/222615J08-9.png "width =" 511 "height =" 345 "/>

Click "new user". In the pop-up window, enter the corresponding user name, password, and password verification method in the "General" option. If you do not change the password, we recommend that you do not select the "force password expiration" option, as shown in:

650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131228/2226153151-6.png "width =" 666 "height =" 458 "/>

In "User correspondence", you need to set the correspondence between the user and the database, and which databases are associated with the user. As shown in:

650) this. width = 650; "style =" background-image: none; margin: 0px; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; "title =" clip_image014 "border =" 0 "alt =" clip_image014 "src =" http://www.bkjia.com/uploads/allimg/131228/2226155924-11.png "width =" 483 "height =" 349 "/>

III,Grant Permissions

After the database and the user are created, we need to grant relevant permissions to the user to manage the database under it. Select the new database "tes" and click "user" on the panel to select "database role", for example:

650) this. width = 650; "id =" demo_img_1 "class =" demo_img "border =" 0 "src =" http://www.bkjia.com/uploads/allimg/131228/2226155543-12.png "/>

Select "db_owner" on the new page. This is the database owner permission. Double-click the user "tes" We just added in the new window that appears, and click "save". the permission is granted, as shown in:

650) this. width = 650; "style =" background-image: none; margin: 0px; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; "title =" clip_image016 "border =" 0 "alt =" clip_image016 "src =" http://www.bkjia.com/uploads/allimg/131228/2226152649-13.png "width =" 547 "height =" 346 "/>

The above operations have completed the management of data using Navicat for SQL Server. Are there any mistakes? We can build a website for testing.

I am using the SDCMS website program for testing. I will only conduct relevant tests and will not explain them more.

650) this. width = 650; "style =" background-image: none; border-bottom: 0px; border-left: 0px; border-top: 0px; border-right: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; "title =" clip_image001 [5] "border =" 0 "alt =" clip_image001 [5] "src =" http://www.bkjia.com/uploads/allimg/131228/2226156103-14.png "height =" 262 "/>

650) this. width = 650; "style =" background-image: none; border-bottom: 0px; border-left: 0px; border-top: 0px; border-right: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; "title =" clip_image001 [7] "border =" 0 "alt =" clip_image001 [7] "src =" http://www.bkjia.com/uploads/allimg/131228/2226153O2-15.png "height =" 314 "/>

650) this. width = 650; "style =" background-image: none; border-bottom: 0px; border-left: 0px; border-top: 0px; border-right: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; "title =" clip_image001 [9] "border =" 0 "alt =" clip_image001 [9] "src =" http://www.bkjia.com/uploads/allimg/131228/222615Ja-16.png "height =" 353 "/>

This is very important because of the database configuration.

650) this. width = 650; "style =" background-image: none; border-bottom: 0px; border-left: 0px; border-top: 0px; border-right: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; "title =" clip_image001 [11] "border =" 0 "alt =" clip_image001 [11] "src =" http://www.bkjia.com/uploads/allimg/131228/222615K58-17.png "height =" 492 "/>

This article from the "muddy world" blog, please be sure to keep this source http://ilanni.blog.51cto.com/526870/1228980