bjoern@1252: CREATE USER test IDENTIFIED BY test;
bjoern@2358: -- USER SQL
bjoern@2358: ALTER USER test DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK ;
bjoern@2358: -- QUOTAS
bjoern@1252: ALTER USER test QUOTA UNLIMITED ON USERS;
bjoern@2358: GRANT ALL on "MDSYS"."ALL_SDO_GEOM_METADATA" to test ;
bjoern@1252: GRANT CREATE SESSION TO test ;
bjoern@2336: GRANT CREATE VIEW TO test;
bjoern@1252: GRANT CONNECT, RESOURCE TO test;