# HG changeset patch # User Bjoern Schilberg # Date 1319555996 0 # Node ID 33062484cc565bc89185075a23162e9d12d04bd1 # Parent 441028ca9a2817745ee0760f89cb3d42b3f1e7fe Added explizit TABLESPACE definition for the user. flys-backend/trunk@3078 c6561f87-3c4e-4783-a992-168aeb5c3f6f diff -r 441028ca9a28 -r 33062484cc56 flys-backend/ChangeLog --- a/flys-backend/ChangeLog Tue Oct 25 06:52:32 2011 +0000 +++ b/flys-backend/ChangeLog Tue Oct 25 15:19:56 2011 +0000 @@ -1,3 +1,8 @@ +2011-10-25 Bjoern Schilberg + + * doc/schema/oracle_create_user.sql: + Added explizit TABLESPACE definition for the user. + 2011-10-25 Bjoern Schilberg * doc/schema/oracle_create_user.sql: diff -r 441028ca9a28 -r 33062484cc56 flys-backend/doc/schema/oracle_create_user.sql --- a/flys-backend/doc/schema/oracle_create_user.sql Tue Oct 25 06:52:32 2011 +0000 +++ b/flys-backend/doc/schema/oracle_create_user.sql Tue Oct 25 15:19:56 2011 +0000 @@ -1,8 +1,11 @@ +--CREATE TABLESPACE for user +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; +--CREATE USER CREATE USER test IDENTIFIED BY test; -- USER SQL -ALTER USER test DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK ; --- QUOTAS -ALTER USER test QUOTA UNLIMITED ON USERS; +ALTER USER test DEFAULT TABLESPACE test TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK ; +-- QUOTA for user on TABLESPACE +ALTER USER test QUOTA UNLIMITED ON test; GRANT ALL on "MDSYS"."ALL_SDO_GEOM_METADATA" to test ; GRANT CREATE SESSION TO test ; GRANT CREATE VIEW TO test;