Mercurial > dive4elements > river
annotate flys-backend/doc/schema/oracle_create_user.sql @ 4255:670e98f5a441
Fixed leak while merging facets.
The ThemeList that is used by OutputHelper to sort the
Facets for an Output now uses a list to store the ManagedFacets.
The correct order is made up by sorting the List using
Collections.sort() function of the Java JDK. Therfore, the
ManagedFacet class implements the Comparable interface. The
return value of its compareTo(other) method depends on the
value of the 'position' field.
| author | Ingo Weinzierl <weinzierl.ingo@googlemail.com> |
|---|---|
| date | Thu, 25 Oct 2012 14:01:46 +0200 |
| parents | ce4c7045afc1 |
| children |
| rev | line source |
|---|---|
|
2359
33062484cc56
Added explizit TABLESPACE definition for the user.
Bjoern Schilberg <bjoern@intevation.de>
parents:
2358
diff
changeset
|
1 --CREATE TABLESPACE for user |
|
33062484cc56
Added explizit TABLESPACE definition for the user.
Bjoern Schilberg <bjoern@intevation.de>
parents:
2358
diff
changeset
|
2 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; |
|
33062484cc56
Added explizit TABLESPACE definition for the user.
Bjoern Schilberg <bjoern@intevation.de>
parents:
2358
diff
changeset
|
3 --CREATE USER |
|
1252
d00a50c69a67
Added inital oracle_create_user.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff
changeset
|
4 CREATE USER test IDENTIFIED BY test; |
|
2358
441028ca9a28
Adjusted oracle_create_user.sql script. Added USER SQL snippet to change tablespace to users.
Bjoern Schilberg <bjoern@intevation.de>
parents:
2336
diff
changeset
|
5 -- USER SQL |
|
2368
ce4c7045afc1
Fixed oracle_create_user.sql script: Fixed notation of the table in the alter statement.
Bjoern Schilberg <bjoern@intevation.de>
parents:
2359
diff
changeset
|
6 ALTER USER test DEFAULT TABLESPACE "test" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK ; |
|
2359
33062484cc56
Added explizit TABLESPACE definition for the user.
Bjoern Schilberg <bjoern@intevation.de>
parents:
2358
diff
changeset
|
7 -- QUOTA for user on TABLESPACE |
|
2368
ce4c7045afc1
Fixed oracle_create_user.sql script: Fixed notation of the table in the alter statement.
Bjoern Schilberg <bjoern@intevation.de>
parents:
2359
diff
changeset
|
8 ALTER USER test QUOTA UNLIMITED ON "test"; |
|
2358
441028ca9a28
Adjusted oracle_create_user.sql script. Added USER SQL snippet to change tablespace to users.
Bjoern Schilberg <bjoern@intevation.de>
parents:
2336
diff
changeset
|
9 GRANT ALL on "MDSYS"."ALL_SDO_GEOM_METADATA" to test ; |
|
1252
d00a50c69a67
Added inital oracle_create_user.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff
changeset
|
10 GRANT CREATE SESSION TO test ; |
|
2336
60c722dc0304
Added right to create views.
Bjoern Schilberg <bjoern@intevation.de>
parents:
1252
diff
changeset
|
11 GRANT CREATE VIEW TO test; |
|
1252
d00a50c69a67
Added inital oracle_create_user.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff
changeset
|
12 GRANT CONNECT, RESOURCE TO test; |