Coba pakai option AUTHID CURRENT_USER karena defaultnya AUTHID DEFINER.
create procedure abc AUTHID CURRENT_USER as x tbl.klm%type; begin select klm into x from tbl where rownum<2; dbms_output.put_line(x); end; Bowo --- In [email protected], "joey" <[EMAIL PROTECTED]> wrote: > > HI, mau nanya lagi ... > > Misalnya saya punya prosedur sederhana seperti berikut : > > create procedure abc as > x tbl.klm%type; > begin > select klm into x from tbl where rownum<2; > dbms_output.put_line(x); > end; > > Pertanyaan saya, bagaimana cara membuat owner tabel tersebut dynamic? > Contoh kasus : > Asumsinya, > - procedure abc dimiliki oleh user AA > - procedure abc digrant ke public > - tabel tbl dimiliki semua user di database dengan struktur yang sama > tetapi dengan data yang berbeda-beda > Tujuan : > Agar user BB bisa mengexecute proc abc tapi data yang keluar adalah > data punya user BB. > > Mohon bantuannya.Trims > > Joey -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
