Mercurial > dive4elements > river
view flys-backend/doc/schema/oracle_create_user.sql @ 2339:b28ab244a77d
Harmonized oracle and postgresql spatial schema.
flys-backend/trunk@2817 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Bjoern Schilberg <bjoern@intevation.de> |
|---|---|
| date | Fri, 23 Sep 2011 10:42:25 +0000 |
| parents | 60c722dc0304 |
| children | 441028ca9a28 |
line wrap: on
line source
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 CREATE VIEW TO test; GRANT CONNECT, RESOURCE TO test;