CodeDogg

DROP USER paki1 CASCADE;

CREATE USER paki1 IDENTIFIED BY paki1 DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP

PROFILE DEFAULT

ACCOUNT UNLOCK;

GRANT CREATE SESSION, CREATE TABLE, CREATE VIEW, CREATE SYNONYM, SELECT ANY DICTIONARY, CREATE SEQUENCE, GRANT ANY PRIVILEGE,

UNLIMITED TABLESPACE,CREATE TRIGGER TO paki1;

ALTER USER paki1 quota unlimited ON users;

DROP USER paki2 CASCADE;

CREATE USER paki2 IDENTIFIED BY paki2 DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP

PROFILE DEFAULT

ACCOUNT UNLOCK;

GRANT CREATE SESSION, CREATE TABLE, CREATE VIEW, CREATE SYNONYM, SELECT ANY DICTIONARY, CREATE SEQUENCE, GRANT ANY PRIVILEGE,

UNLIMITED TABLESPACE,CREATE TRIGGER TO paki2;

ALTER USER paki2 quota unlimited ON users;

DROP USER paki3 CASCADE;

CREATE USER paki3 IDENTIFIED BY paki3 DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP

PROFILE DEFAULT

ACCOUNT UNLOCK;

GRANT CREATE SESSION, CREATE TABLE, CREATE VIEW, CREATE SYNONYM, SELECT ANY DICTIONARY, CREATE SEQUENCE, GRANT ANY PRIVILEGE,

UNLIMITED TABLESPACE,CREATE TRIGGER TO paki3;

ALTER USER paki3 quota unlimited ON users;

DROP USER paki4 CASCADE;

CREATE USER paki4 IDENTIFIED BY paki4 DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP

PROFILE DEFAULT

ACCOUNT UNLOCK;

GRANT CREATE SESSION, CREATE TABLE, CREATE VIEW, CREATE SYNONYM, SELECT ANY DICTIONARY, CREATE SEQUENCE, GRANT ANY PRIVILEGE,

UNLIMITED TABLESPACE,CREATE TRIGGER TO paki4;

ALTER USER paki4 quota unlimited ON users;

DROP USER pakicont1 CASCADE;

CREATE USER pakicont1 IDENTIFIED BY pakicont1 DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP

PROFILE DEFAULT

ACCOUNT UNLOCK;

GRANT CREATE SESSION, CREATE TABLE, CREATE VIEW, CREATE SYNONYM, SELECT ANY DICTIONARY, CREATE SEQUENCE, GRANT ANY PRIVILEGE,

UNLIMITED TABLESPACE,CREATE TRIGGER TO pakicont1;

ALTER USER pakicont1 quota unlimited ON users;

DROP USER pakicont2 CASCADE;

CREATE USER pakicont2 IDENTIFIED BY pakicont2 DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP

PROFILE DEFAULT

ACCOUNT UNLOCK;

GRANT CREATE SESSION, CREATE TABLE, CREATE VIEW, CREATE SYNONYM, SELECT ANY DICTIONARY, CREATE SEQUENCE, GRANT ANY PRIVILEGE,

UNLIMITED TABLESPACE,CREATE TRIGGER TO pakicont2;

ALTER USER pakicont2 quota unlimited ON users;

DROP USER pakicont3 CASCADE;

CREATE USER pakicont3 IDENTIFIED BY pakicont3 DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP

PROFILE DEFAULT

ACCOUNT UNLOCK;

GRANT CREATE SESSION, CREATE TABLE, CREATE VIEW, CREATE SYNONYM, SELECT ANY DICTIONARY, CREATE SEQUENCE, GRANT ANY PRIVILEGE,

UNLIMITED TABLESPACE,CREATE TRIGGER TO pakicont3;

ALTER USER pakicont3 quota unlimited ON users;

DROP USER pakicont4 CASCADE;

CREATE USER pakicont4 IDENTIFIED BY pakicont4 DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP

PROFILE DEFAULT

ACCOUNT UNLOCK;

GRANT CREATE SESSION, CREATE TABLE, CREATE VIEW, CREATE SYNONYM, SELECT ANY DICTIONARY, CREATE SEQUENCE, GRANT ANY PRIVILEGE,

UNLIMITED TABLESPACE,CREATE TRIGGER TO pakicont4;

ALTER USER pakicont4 quota unlimited ON users;