1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
\set ORACLE_USER system
\set ORACLE_PASS oracle
\set ORACLE_SVC xe
\set ORACLE_HOST `docker port oracle 1521`
\prompt NAME 'Create database user: '
\prompt -password PASS 'Password for "':NAME'": '
\connect 'oracle://':ORACLE_USER':':ORACLE_PASS'@':ORACLE_HOST'/':ORACLE_SVC
\set DATNAME :NAME.dat
CREATE
TABLESPACE :NAME
NOLOGGING
DATAFILE :'DATNAME'
SIZE 100m
AUTOEXTEND ON;
CREATE
USER :NAME
IDENTIFIED BY :NAME
DEFAULT TABLESPACE :NAME;
GRANT
CREATE SESSION,
CREATE TABLE,
CREATE VIEW,
CREATE SEQUENCE,
CREATE PROCEDURE,
CREATE TRIGGER,
UNLIMITED TABLESPACE,
SELECT ANY DICTIONARY
TO :NAME;
ALTER SYSTEM
SET OPEN_CURSORS=400
SCOPE=both;
|
