JDBC for Oracle - Herong's Tutorial Examples - v3.13, by Herong Yang
Archived: Creating Oracle Database Users
This section describes how to create a database user on the Oracle server through the Web interface.
During the installation process, only one administration login user was created on the Oracle server. When connecting Java programs to the server, it's better to use a regular login user. Here is what I did to create a user called "Herong" through the Web interface.
- Run IE with http://localhost:8080/apex.
- Login with "SYSTEM/Yang".
- Click on the Administration menu icon, and select "Database User" > "Create User". I got the Create Database User page.
- Enter "Herong" as Username and "TopSecret" as Password. Check the "CREATE TABLE" and other privileges.
- Click the Create button. User "Herong" is created. See the user list page below:
Note that "HR" is another login user that provided by the installation process for tutorial demonstration purpose.
Table of Contents
JDBC (Java Database Connectivity) Introduction
Oracle Express Edition Installation on Windows
Oracle - Reference Implementation of JdbcRowSet
Oracle - JBDC CallableStatement
Oracle CLOB (Character Large Object) - TEXT
Oracle BLOB (Binary Large Object) - BLOB
Using Connection Pool with JDBC
Archived: Downloading and Installing JDK 13 on Mac
Archived: Downloading and Installing JDK 12 on Windows
Archived: Java SE 8 Installation
Archived: Java SE 1.6 Update 2 Installation
Archived: JDK 1.6 Documentation Installation
Archived: Oracle Database Express Edition (XE) Installation
Archived: Accessing Oracle Server through Web Interface
►Archived: Creating Oracle Database Users
Archived: SQL*Plus - Oracle Command Line Interface