Mud: Use Navicat for Oracle to create tablespaces, grant users and permissions

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

In the previous article, I introduced how to use Navicat for SQLServer. Today I will introduce its fellow teacher Navicat for Oracle.

Navicat for Oracle is a client tool for Oracle databases. Through this client, we can operate the Oracle database graphically.

It indicates that the Oracle database version we tested in this experiment is Oracle 10G Express Edition, which is also known as Oracle XE. This version is sufficient for us to learn. We only need to know that the general Oracle database version we use is the Enterprise Edition, because the Oracle database version is more than here I will not introduce it too much.

I will not introduce Oracle XE database installation this time. If I have time, I will write a separate article about XE. After the XE database is installed, we can connect to the database. When connecting to the database, you only need to note that the XE version instance is XE, and the default instance of the Enterprise version is Orcl.

First, create a new tablespace. Open Navicat for Oracle and enter relevant connection information. For example:

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/222135M37-0.png "width =" 511 "height =" 568 "/>

Enter the correct information and connect. Click the "tablespace" option under "Others" on the panel, for example:

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/2221351R2-1.png "width =" 543 "height =" 338 "/>

On the tablespace page, you can use the "Create tablespace" button on the panel or right-click a blank space to create a tablespace, for example:

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/222135O29-2.png "width =" 541 "height =" 312 "/>

In the pop-up interface, enter the name of the tablespace, the name of the file to be stored in the physical disk of oracle, and the initial size and unit of the tablespace. In the path option, enter the physical disk path of the tablespace. Select "on" in the "auto scaling" option to allow you to manually expand the tablespace. If "off" is selected, the tablespace size is fixed and cannot be expanded. Specific instance, such:

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/2221351F4-3.png "width =" 531 "height =" 475 "/>

The following is the SQL language used to create a tablespace:

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/2221355A4-4.png "width =" 998 "height =" 224 "/>

After entering other information, click "save. The system prompts an interface to enter the name of the tablespace, for example:

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/222135J03-5.png "width =" 641 "height =" 329 "/>

After creating a new table, we can check whether there are any tablespace files on the disk in the House, for example:

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_image007 "border =" 0 "alt =" clip_image007 "src =" http://www.bkjia.com/uploads/allimg/131228/2221351123-6.png "width =" 482 "height =" 311 "/>

After creating a tablespace, we will create a user. Click the "user" option on the panel, for example:

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_image008 "border =" 0 "alt =" clip_image008 "src =" http://www.bkjia.com/uploads/allimg/131228/22213511L-7.png "width =" 543 "height =" 458 "/>

There are two ways to create a user. One is the "create user" button on the control panel, and the other is to right-click the blank button, as shown in. After clicking "create user", enter relevant information in the pop-up interface. For example:

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_image009 "border =" 0 "alt =" clip_image009 "src =" http://www.bkjia.com/uploads/allimg/131228/222135GS-8.png "width =" 508 "height =" 353 "/>

Note that the username letter must beUppercase.Remember that it must be in upper case. If it is in lower case, this user cannot connect to the Oracle database.I think this may be a BUG in the software. In "default tablespace", select the tablespace we created before science. If this parameter is not selected, the system's default tablespace USERS will be used.

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://www.bkjia.com/uploads/allimg/131228/2221355147-9.png "width =" 469 "height =" 322 "/>

In "member belongs", we select the "DBA" permission. In fact, for general users, we only need to grant the connect, resource, and create view permissions. But here we select "DBA" for demonstration convenience. Grant the connect, resource, and create view permissions. You can see:

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/222135C19-10.png "width =" 500 "height =" 468 "/>

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_image012 "border =" 0 "alt =" clip_image012 "src =" http://www.bkjia.com/uploads/allimg/131228/2221356147-11.png "width =" 549 "height =" 427 "/>

After completing the preceding operations, you can switch to the "SQL preview" option to view related SQL statements, such:

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_image013 "border =" 0 "alt =" clip_image013 "src =" http://www.bkjia.com/uploads/allimg/131228/2221351117-12.png "width =" 998 "height =" 203 "/>

After the user is created, we can use this database. Let's test whether the user can connect to the Oracle database normally.

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/2221351230-13.png "width =" 507 "height =" 559 "/>

We can see that the user we just created can connect to the database normally.

However, the database is created correctly and cannot be used normally. This requires an actual project verification.

OK. I have a project on the OA system at hand. Now let's import the database. The related import statements are as follows:

Imp ilanni/ilanni @ localhost:/xe fromuser = jy touser = ilanni file = d: \ jy. dmp buffer = 102400

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_image015 "border =" 0 "alt =" clip_image015 "src =" http://www.bkjia.com/uploads/allimg/131228/2221352463-14.png "width =" 751 "height =" 313 "/>

Open "start"-"run"-CDM, and paste the statement.

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/222135J14-15.png "width =" 696 "height =" 455 "/>

After running, we can start the system. The specific startup method package contains relevant instructions. What is the interface after normal startup:

650) this. width = 650; "style =" background-image: none; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; "title =" clip_image017 "border =" 0 "alt =" clip_image017 "src =" http://www.bkjia.com/uploads/allimg/131228/222135D22-16.png "width =" 478 "height =" 352 "/>

This is the prompt for normal system access.

OK, so far we have finished introducing the use of Navicat for Oracle. The next article describes how to use Navicat for Mysql.

PS: click "51cto.com" to download the project files required for this test.

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