view backend/doc/schema/oracle_create_user.sql @ 8443:df65f24af5bc

(issue1762) Use getValue to obtain dateRange values The getToValue was always the initial value regardless of what has been entered in the form. According to the documentation both getToValue and getFromValue should return the "initial value" of the form field. But wether this means the value before validation corrections or the value the field is initialized with (which is also not true in both cases as the field is set only after creation) It returned the real value for the from date but not for the to date. With an explicit getValue we workaround this issue.
author Andre Heinecke <andre.heinecke@intevation.de>
date Wed, 22 Oct 2014 17:33:43 +0200
parents 5aa05a7a34b7
children
line wrap: on
line source
--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 "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;
GRANT CONNECT, RESOURCE TO test;

http://dive4elements.wald.intevation.org