Tworzenie użytkownika w Oracle

CREATE USER [user] IDENTIFIED BY [password];
GRANT CONNECT TO [user];
GRANT CREATE TABLE TO [user];
ALTER USER [user] QUOTA UNLIMITED ON users;

Tworzenie użytkownika na Oracle

CREATE USER ziomal IDENTIFIED BY q1w2e3r4 DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp;
GRANT CREATE SESSION, UNLIMITED TABLESPACE, CREATE TABLE, CREATE CLUSTER, CREATE SEQUENCE, CREATE PROCEDURE, CREATE TRIGGER, CREATE TYPE, CREATE OPERATOR, CREATE INDEXTYPE TO ziomal;