1 -- ==================================================== --
4 -- This script is run as user "sys" --
6 -- creates user "backup" identified externally --
7 -- creates role "backup_role" with permisssions --
8 -- grants role "backup_role" to user "backup" --
10 -- ==================================================== --
13 create role backup_role;
14 grant create session to backup_role;
15 grant alter system to backup_role;
16 grant alter database to backup_role;
17 grant manage tablespace to backup_role;
18 grant select on dba_tablespaces to backup_role;
19 grant select on dba_data_files to backup_role;
20 grant select on v_$log to backup_role;
22 create user backup identified externally;
23 grant backup_role to backup;