Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle_create_user.sql @ 2358:441028ca9a28
Adjusted oracle_create_user.sql script. Added USER SQL snippet to change tablespace to users.
flys-backend/trunk@3065 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Bjoern Schilberg <bjoern@intevation.de> |
|---|---|
| date | Tue, 25 Oct 2011 06:52:32 +0000 |
| parents | 60c722dc0304 |
| children | 33062484cc56 |
comparison
equal
deleted
inserted
replaced
| 2357:2e18e12fac11 | 2358:441028ca9a28 |
|---|---|
| 1 CREATE USER test IDENTIFIED BY test; | 1 CREATE USER test IDENTIFIED BY test; |
| 2 -- USER SQL | |
| 3 ALTER USER test DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK ; | |
| 4 -- QUOTAS | |
| 2 ALTER USER test QUOTA UNLIMITED ON USERS; | 5 ALTER USER test QUOTA UNLIMITED ON USERS; |
| 3 grant all on "MDSYS"."ALL_SDO_GEOM_METADATA" to test ; | 6 GRANT ALL on "MDSYS"."ALL_SDO_GEOM_METADATA" to test ; |
| 4 GRANT CREATE SESSION TO test ; | 7 GRANT CREATE SESSION TO test ; |
| 5 GRANT CREATE VIEW TO test; | 8 GRANT CREATE VIEW TO test; |
| 6 GRANT CONNECT, RESOURCE TO test; | 9 GRANT CONNECT, RESOURCE TO test; |