Mercurial > dive4elements > river
view backend/doc/schema/oracle_create_user.sql @ 5983:0c63ce5a7e74
Use name id as username in saml.User.
The old WAS-only code used the user-name typed in by the user when
logging in. When logging in via SAML single sign on, we must extract the
user name from the SAML ticket and the name ID should basically be what
the user types in when authenticating.
| author | Bernhard Herzog <bh@intevation.de> |
|---|---|
| date | Fri, 10 May 2013 19:03:48 +0200 |
| parents | 5aa05a7a34b7 |
| children |
line wrap: on
line source
--CREATE TABLESPACE for user 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; --CREATE USER CREATE USER test IDENTIFIED BY test; -- USER SQL ALTER USER test DEFAULT TABLESPACE "test" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK ; -- QUOTA for user on TABLESPACE ALTER USER test QUOTA UNLIMITED ON "test"; 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;