Mercurial > dive4elements > river
annotate backend/doc/schema/oracle_create_user.sql @ 8674:44ba71b0b75a
(issue1763) Correct properties in importer scripts.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Thu, 09 Apr 2015 17:08:51 +0200 |
parents | 5aa05a7a34b7 |
children |
rev | line source |
---|---|
2359
33062484cc56
Added explizit TABLESPACE definition for the user.
Bjoern Schilberg <bjoern@intevation.de>
parents:
2358
diff
changeset
|
1 --CREATE TABLESPACE for user |
33062484cc56
Added explizit TABLESPACE definition for the user.
Bjoern Schilberg <bjoern@intevation.de>
parents:
2358
diff
changeset
|
2 CREATE TABLESPACE "test" DATAFILE '/u01/app/oracle/oradata/XE/test.dbf' SIZE 500M AUTOEXTEND ON NEXT 100M MAXSIZE 1G LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO; |
33062484cc56
Added explizit TABLESPACE definition for the user.
Bjoern Schilberg <bjoern@intevation.de>
parents:
2358
diff
changeset
|
3 --CREATE USER |
1252
d00a50c69a67
Added inital oracle_create_user.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff
changeset
|
4 CREATE USER test IDENTIFIED BY test; |
2358
441028ca9a28
Adjusted oracle_create_user.sql script. Added USER SQL snippet to change tablespace to users.
Bjoern Schilberg <bjoern@intevation.de>
parents:
2336
diff
changeset
|
5 -- USER SQL |
2368
ce4c7045afc1
Fixed oracle_create_user.sql script: Fixed notation of the table in the alter statement.
Bjoern Schilberg <bjoern@intevation.de>
parents:
2359
diff
changeset
|
6 ALTER USER test DEFAULT TABLESPACE "test" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK ; |
2359
33062484cc56
Added explizit TABLESPACE definition for the user.
Bjoern Schilberg <bjoern@intevation.de>
parents:
2358
diff
changeset
|
7 -- QUOTA for user on TABLESPACE |
2368
ce4c7045afc1
Fixed oracle_create_user.sql script: Fixed notation of the table in the alter statement.
Bjoern Schilberg <bjoern@intevation.de>
parents:
2359
diff
changeset
|
8 ALTER USER test QUOTA UNLIMITED ON "test"; |
2358
441028ca9a28
Adjusted oracle_create_user.sql script. Added USER SQL snippet to change tablespace to users.
Bjoern Schilberg <bjoern@intevation.de>
parents:
2336
diff
changeset
|
9 GRANT ALL on "MDSYS"."ALL_SDO_GEOM_METADATA" to test ; |
1252
d00a50c69a67
Added inital oracle_create_user.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff
changeset
|
10 GRANT CREATE SESSION TO test ; |
2336
60c722dc0304
Added right to create views.
Bjoern Schilberg <bjoern@intevation.de>
parents:
1252
diff
changeset
|
11 GRANT CREATE VIEW TO test; |
1252
d00a50c69a67
Added inital oracle_create_user.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff
changeset
|
12 GRANT CONNECT, RESOURCE TO test; |