How to Set Up a Database User and an Oracle APEX Workspace on Your Server

  1. Connect to Server
    ssh user@hostname

 

  1. Switch to Oracle User
    sudo su - oracle
  2. Connect as SYSDBA
    sqlplus / as sysdba

 

  1. Set PDB
    ALTER SESSION SET CONTAINER = pdbname;

 

  1. Create User (Schema)
    CREATE USER testing IDENTIFIED BY test_password;

 

  1. Grant Privileges
    GRANT CONNECT, RESOURCE TO testing;
    GRANT CREATE VIEW, CREATE SEQUENCE TO testing;

 

  1. Connect as New User
    CONN testing/test_password@pdbname

 

8.How to Create APEX Workspace
Login to Oracle APEX as Internal Admin

 

Create Workspace
Type: Existing Schema
Schema: TESTING
Workspace Name: TESTING
Admin Username: testing@gmail.com
Set Password
Click Create Workspace

 

  1. Login to Workspace

 

Workspace: TESTING
Username: testing@gmail.com
Password: (your password)

 

 

  • Workspace Creation, Database user, Oracle APEX
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Oracle Text not working on Linux

Oracle Text executable ctxhx requires libstdc++.so.5 library whereas most Linux distribution...

ORA-00603: ORACLE server session terminated by fatal error

If you get following error in SQL Developer:ORA-00603: ORACLE server session terminated by fatal...

How to connect SQL Developer Connection Tutorial Video

Database Connection Details for SQL Tools:  Open Oracle SQL Developer.Once it loads, click...