dive4elements/river: flys-backend/doc/schema/oracle_create_user.sql annotate

annotate flys-backend/doc/schema/oracle_create_user.sql @ 4573:b87073a05f9d

flys-client: Patch to render combobox options as clickable links. The way of passing data arguments to the links and further to the Artifact feeding service is somewhat hacked and should be refactored (later...).

author	Christian Lins <christian.lins@intevation.de>
date	Tue, 27 Nov 2012 12:50:10 +0100
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;

http://dive4elements.wald.intevation.org