declare
v_grant varchar2 (500);
begin
for cur in (select distinct table_name from user_tables)
loop
v_grant :=' grant select on ' || cur.table_name || ' to orhan';
execute immediate v_grant;
dbms_output.put_line(v_grant);
end loop;
end;
26 Haziran 2009 Cuma
Kaydol:
Kayıt Yorumları (Atom)
0 yorum:
Yorum Gönder