Mercurial > dive4elements > river
annotate flys-backend/doc/schema/oracle_create_user.sql @ 2337:52d712cd2384
Added code and a system property 'flys.backend.enablejmx=true' to enable JMX support for hibernate.
flys-backend/trunk@2808 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Thu, 22 Sep 2011 11:20:15 +0000 |
| parents | 60c722dc0304 |
| children | 441028ca9a28 |
| rev | line source |
|---|---|
|
1252
d00a50c69a67
Added inital oracle_create_user.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff
changeset
|
1 CREATE USER test IDENTIFIED BY test; |
|
d00a50c69a67
Added inital oracle_create_user.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff
changeset
|
2 ALTER USER test QUOTA UNLIMITED ON USERS; |
|
d00a50c69a67
Added inital oracle_create_user.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff
changeset
|
3 grant all on "MDSYS"."ALL_SDO_GEOM_METADATA" to test ; |
|
d00a50c69a67
Added inital oracle_create_user.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff
changeset
|
4 GRANT CREATE SESSION TO test ; |
|
2336
60c722dc0304
Added right to create views.
Bjoern Schilberg <bjoern@intevation.de>
parents:
1252
diff
changeset
|
5 GRANT CREATE VIEW TO test; |
|
1252
d00a50c69a67
Added inital oracle_create_user.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff
changeset
|
6 GRANT CONNECT, RESOURCE TO test; |