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.