Mercurial > dive4elements > river
changeset 2336:60c722dc0304
Added right to create views.
flys-backend/trunk@2796 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Bjoern Schilberg <bjoern@intevation.de> |
|---|---|
| date | Wed, 21 Sep 2011 10:12:00 +0000 |
| parents | e1fb4a1e0b4a |
| children | 52d712cd2384 |
| files | flys-backend/ChangeLog flys-backend/doc/schema/oracle_create_user.sql |
| diffstat | 2 files changed, 5 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/flys-backend/ChangeLog Tue Sep 20 13:21:29 2011 +0000 +++ b/flys-backend/ChangeLog Wed Sep 21 10:12:00 2011 +0000 @@ -1,3 +1,7 @@ +2011-09-20 Bjoern Schilberg <bjoern@intevation.de> + + * doc/schema/oracle_create_user.sql: Added right to create views. + 2011-09-20 Bjoern Schilberg <bjoern@intevation.de> * doc/schema/oracle-spatial.sql: Generalized oracle spatial schema.
--- a/flys-backend/doc/schema/oracle_create_user.sql Tue Sep 20 13:21:29 2011 +0000 +++ b/flys-backend/doc/schema/oracle_create_user.sql Wed Sep 21 10:12:00 2011 +0000 @@ -2,4 +2,5 @@ ALTER USER test QUOTA UNLIMITED ON USERS; 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;