view backend/doc/schema/oracle_create_user.sql @ 8730:cb33de3434a8

(issue1754) Proper subtitle handling for Radius This deduplicates the subtitle and zoom / radius calculation code by moving it out of the processors. Doing this fixes cases where the subtitle would be removed when a the according filtered facet was removed although it should still have shown the Range for example. Range is now also added as a subtitle for the difference diagrams. This adds some tasty hack (with cheese) to determine wether or not the user has set the subtitle. See the comment in getChartSubtitlePure in LongitudinalSectionGenerator2 for details.
author Andre Heinecke <andre.heinecke@intevation.de>
date Thu, 30 Apr 2015 13:06:51 +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