# HG changeset patch
# User Bjoern Schilberg <bjoern@intevation.de>
# Date 1316009390 0
# Node ID d00a50c69a67ff34e62b3a0ef2941c4d709e8690
# Parent  f124c99077b546cd0579398970a7b4b30e9ecaa8
Added inital oracle_create_user.sql script.


flys-backend/trunk@2742 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r f124c99077b5 -r d00a50c69a67 flys-backend/ChangeLog
--- 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.
diff -r f124c99077b5 -r d00a50c69a67 flys-backend/doc/schema/oracle_create_user.sql
--- /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;