Create User in Oracle

1. download DbVisualizer Free 6.0.8

2. Set up Oracle connection

3. In SQL Commander tab run these SQL statements to create a user

CREATE USER jwnickol IDENTIFIED BY marathon DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP PROFILE DEFAULT;

ALTER USER jwnickol QUOTA 0 ON SYSTEM;

ALTER USER jwnickol QUOTA UNLIMITED ON USERS;

GRANT CREATE SESSION TO jwnickol;

GRANT ALTER SESSION TO jwnickol;

GRANT SELECT ANY TABLE TO jwnickol;

grant create table to jwnickol;

After I added this I could create schema etc.

grant all privileges to jwnickol;