create user          tibesti_portal
identified by        tibesti_portal
default   tablespace users
temporary tablespace temp
QUOTA 0 ON SYSTEM
QUOTA 0 ON SYSAUX
QUOTA unlimited ON users;
-- QUOTA 10000M ON temp

grant CREATE ANY INDEX to tibesti_portal;
grant CREATE ANY INDEXTYPE to tibesti_portal;
grant CREATE ANY MATERIALIZED VIEW to tibesti_portal;
grant CREATE ANY PROCEDURE to tibesti_portal;
grant CREATE ANY SEQUENCE to tibesti_portal;
grant CREATE ANY TABLE to tibesti_portal;
grant ALTER ANY MATERIALIZED VIEW to tibesti_portal;
grant ALTER ANY TABLE to tibesti_portal;
grant ALTER ANY TRIGGER to tibesti_portal;
grant CREATE ANY TRIGGER to tibesti_portal;
grant CREATE ANY TYPE to tibesti_portal;
grant CREATE ANY VIEW to tibesti_portal;
grant DELETE ANY TABLE to tibesti_portal;
grant DROP ANY MATERIALIZED VIEW to tibesti_portal;
grant DROP ANY INDEX to tibesti_portal;
grant DROP ANY PROCEDURE to tibesti_portal;
grant DROP ANY SEQUENCE to tibesti_portal;
grant DROP ANY TABLE to tibesti_portal;
grant DROP ANY TRIGGER to tibesti_portal;
grant DROP ANY VIEW to tibesti_portal;
grant EXECUTE ANY PROCEDURE to tibesti_portal;
grant SELECT ANY TABLE to tibesti_portal;
grant SELECT ANY SEQUENCE to tibesti_portal;
grant CREATE SESSION to tibesti_portal;
grant create any type to tibesti_portal;

commit;

