create or replace view MUAYENELER as
select h.hasta_no,h.hasta_adi,k.klinik_adi from hastalar h join klinik k
on(h.klinik_id=k.klinik_id);

select * from muayeneler;

grant select on MUAYENELER to ahmet;

conn ahmet

select * from orhan.muayeneler;

drop view muayeneler;
——————————————————————————-

select * from user_objects;