CREATE VIEW prv_instance as select instance_name, host_name from v$instance; CREATE ROLE dba_read_role; grant select on prv_instance to dba_read_role; grant dba_read_role to hajo;