Mercurial > dive4elements > river
annotate backend/doc/schema/oracle_create_user.sql @ 5890:6ea004d51203
Datacage: Introduced <dc:group epxr="xpath" type="type"> ... </dc:group> and XPath function dc:group-key().
This splits the current result set into groups formed by expr. The type defaults to string.
Afterwards all these groups are iterated by there natural order.
The dc:group-key() gives access to the result of the grouping expression that forms a group.
Say, you have a result set like this:
name | description
-----+------------
a | foo
a | bar
b | baz
b | bla
c | blub
you can use:
<dc:group expr="$name">
<group name="{dc:group-key()}">
<dc:for-each>
<description value="{$description}"/>
</dc:for-each>
</group>
</dc:group>
to create:
<group name="a">
<description name="foo"/>
<description name="bar"/>
</group>
<group name="b">
<description name="baz"/>
<description name="bla"/>
</group>
<group name="c">
<description name="blub"/>
</group>
author | Sascha L. Teichmann <teichmann@intevation.de> |
---|---|
date | Thu, 02 May 2013 20:52:18 +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; |