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
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
SET FEEDBACK 1
SET ECHO OFF
Prompt Connecting as SYSTEM to create hr
Connect system/oracle@localhost:1521/orcl
spool cre_hr.log
Prompt Dropping user hr
DROP USER hr CASCADE;
Prompt Creating user hr
CREATE USER hr IDENTIFIED BY oracle
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp
QUOTA UNLIMITED ON users;
Prompt Setting permissions for user hr
GRANT create session
, create table
, create procedure
, create sequence
, create trigger
, create view
, create synonym
, alter session
, create type
, create materialized view
, query rewrite
, create dimension
, create any directory
, alter user
, resumable
, ALTER ANY TABLE -- These
, DROP ANY TABLE -- five are
, LOCK ANY TABLE -- needed
, CREATE ANY TABLE -- to use
, SELECT ANY TABLE -- DBMS_REDEFINITION
TO hr;
GRANT select_catalog_role
, execute_catalog_role
TO hr;
Prompt Connecting as user hr
CONNECT hr/oracle@localhost:1521/orcl
Prompt Installing current_oracle.sql
@current_oracle.sql
spool off
|
