— cre_dbav_usr
— create a schema to be used by dba’s for viewing and testing any database.
— Need to alter ts’s for each instance.
— Where can, use temp_02 and data_01
drop user dbaview cascade;

create user dbaview identified by &1
temporary tablespace temp_01
default tablespace   data_01
/
grant connect to dbaview;
grant resource to dbaview;
grant select any table to dbaview;
grant unlimited tablespace to dbaview;