changeset 1252:d00a50c69a67

Added inital oracle_create_user.sql script. flys-backend/trunk@2742 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Bjoern Schilberg <bjoern@intevation.de>
date Wed, 14 Sep 2011 14:09:50 +0000 (2011-09-14)
parents f124c99077b5
children a75e7d922942
files flys-backend/ChangeLog flys-backend/doc/schema/oracle_create_user.sql
diffstat 2 files changed, 10 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/flys-backend/ChangeLog	Wed Sep 14 10:05:09 2011 +0000
+++ b/flys-backend/ChangeLog	Wed Sep 14 14:09:50 2011 +0000
@@ -1,3 +1,8 @@
+2011-09-14  Bjoern Schilberg <bjoern@intevation.de>
+
+	*  doc/schema/oracle_create_user.sql: Added inital oracle_create_user.sql
+	   script.
+
 2011-09-14  Bjoern Schilberg <bjoern@intevation.de>
 
 	*  doc/schema/oracle-spatial.sql: Added schema floodplain.
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/flys-backend/doc/schema/oracle_create_user.sql	Wed Sep 14 14:09:50 2011 +0000
@@ -0,0 +1,5 @@
+CREATE USER test IDENTIFIED BY test;
+ALTER USER test QUOTA UNLIMITED ON USERS;
+grant all on "MDSYS"."ALL_SDO_GEOM_METADATA" to test ;
+GRANT CREATE SESSION TO test ;
+GRANT CONNECT, RESOURCE TO test;

http://dive4elements.wald.intevation.org