Mercurial > dive4elements > river
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;