Mercurial > dive4elements > river

annotate backend/doc/schema/oracle_create_user.sql @ 8581:073ea4bcea58

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
(issue1755) Interpolate BedQuality Results This adds an interpolation function to each various bedQuality result class. Imho this is ok as the interpolation function can be seen as part of the result. The interpolation function is initalized on first use and can be accessed through get.*Interpol functions.
author Andre Heinecke <andre.heinecke@intevation.de>
date Mon, 16 Mar 2015 15:36:38 +0100
parents 5aa05a7a34b7
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;
http://dive4elements.wald.intevation.org