-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathawr_r2_0_createuser.sql
23 lines (23 loc) · 1.02 KB
/
awr_r2_0_createuser.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
----------------------------------------------------------------------------------------
-- CREATE USER
----------------------------------------------------------------------------------------
connect / as sysdba
drop user r2toolkit cascade;
create user r2toolkit identified by r2toolkit account unlock;
grant create session to r2toolkit;
grant create table to r2toolkit;
grant create view to r2toolkit;
grant create procedure to r2toolkit;
grant unlimited tablespace to r2toolkit;
grant select on dba_hist_snapshot to r2toolkit;
grant select on dba_hist_database_instance to r2toolkit;
grant select on dba_hist_sysstat to r2toolkit;
grant select on dba_hist_system_event to r2toolkit;
grant select on dba_hist_sys_time_model to r2toolkit;
grant select on dba_hist_osstat to r2toolkit;
grant select on dba_hist_sys_time_model to r2toolkit;
grant select on dba_hist_wr_control to r2toolkit;
grant select on v_$datafile to r2toolkit;
grant select on v_$database to r2toolkit;
grant select on v_$instance to r2toolkit;
connect r2toolkit/r2toolkit