1 1g will bring its own sql.

Developer tools, open sql.

Developers,

2 in sql

In developer, we create a new connection, and then click the "green plus sign" in the upper left corner.

3 After the configuration is completed, you can click "Test" to test whether the database connection is correct. As shown in the above figure, "Status: Success" in the lower left corner indicates that the database connection is correct.

Create a new user

1 Connect to the login database.

Then create a new user for the orcl database.

3 Fill in the user name and password, and specify the tablespace for the user.

4 Assign permissions to users

5. View the sql codes corresponding to creating users and assigning permissions.

6 Create a database connection with a new user, and the method of creating a database connection with a new account is similar to the first step.