bjoern@2359: --CREATE TABLESPACE for user
bjoern@2359: CREATE TABLESPACE "test" DATAFILE '/u01/app/oracle/oradata/XE/test.dbf' SIZE 500M AUTOEXTEND ON NEXT 100M MAXSIZE 1G LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO;
bjoern@2359: --CREATE USER
bjoern@1252: CREATE USER test IDENTIFIED BY test;
bjoern@2358: -- USER SQL
bjoern@2368: ALTER USER test DEFAULT TABLESPACE "test" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK ;
bjoern@2359: -- QUOTA for user on TABLESPACE
bjoern@2368: ALTER USER test QUOTA UNLIMITED ON "test";
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;