How to create a local database, create a new user, and assign permissions to an Oracle database

How to create a local database, create a new user, and assign permissions to an Oracle database

1. oracle can create a local database:

Prerequisites: Install the oracle database client; PL/SQL DEVELOPER

1. Open DatabaseConfiguration Assistant, install it as prompted, and remember the set password. (Create a local database)

(1) Select create database;

(2) select general purpose;

(3) enter your own database name;

(4) enter the password, select the same password, and enter a different password for each user (remember the password );

(5) later, it will be installed by default. After the installation is complete, exit.

2. Enable net manage for database service configuration: (configure Database Service connection information)

(1) Fill in the network service name and fill in one that can mark yourself. In other words, just remember it. The local database is used to indicate different databases, while the Internet is used as the service name for connecting sub-hosts to the local database (such as step 3 );

(2) Select the TCP/IP protocol and next;

(3) enter the host name. Here, you must enter the ip address of the host where the database is located. If it is local, enter 127.0.0.1. You can also access the databases of other hosts by entering the IP address of the corresponding host. Select the default 1521 port.

(4) enter the service name. enter the name of the database you just created. It cannot be entered here. If the database is connected to another host, the correct network service name of the other host database is required (the network service name configured in step 1 is used );

(5) test. Click test. The test window is displayed. In the test window, click Change logon. Enter the system password for the user name, which is the password you entered when creating the database (exercise caution when setting the password when creating the database ). Then confirm the test. If it is entered correctly, the message indicating the test is successful will be displayed.

(6) Click Finish.

2. Create a new user and assign permissions:

1. Use PL/SQL DEVELOPER to log on to the database: (connect to the database)

By default, the created database is passed: User name: system; Password: (password set when the database is created );

2. Create a new user and assign permissions: (create a new user)

(1) After logging on to the System user, you can see the users folder, right-click to create a user, and configure the password and user name on the New user Creation Interface.

(2) Select the role permission column: Select connect and resource in the role.

At this time, the role creation and allocation permissions have been completed, and you can log on with the user name and password.