Hi, Tadinya saya pikir saya bisa buat Grant di Roles. Jadi saya buat Role dan saya grant kesitu, jadi semua bisa Select, Insert, Update dan Delete termasuk buat public synonyms. Tapi ternyata untuk compile trigger harus punya Grant All.
Ok kawan thanks semuanya buat Johanes Benyamin, Agus Winarta & Jimmy. Masalah terpecahkan. Regards, Aria On 6/29/05, jimmy <[EMAIL PROTECTED]> wrote: > Dear aria, > Selain dibuatkan public synonymnya, maka table tersebut juga harus di grant > ke schema A. > grant insert, delete, update, select on CAR to B ; > > semoga ini bisa membantu menyelesaikan masalahnya. > > Regards, > JimmyG > > a_r_i_a <[EMAIL PROTECTED]> wrote: > Hi, > > Terimakasih atas responya. > Saya sudah buat menjadi b.CAR tetapi masih terjadi error yang sama. > > > > On 6/29/05, agus winarta <[EMAIL PROTECTED]> wrote: > > Anda harus menyebutkan dulu schema yang memilki object tabel yang > > bersangkutan. dalam kasus ini, table CAR adalah milik schema b, maka pada > > select statement anda harus menulis b.CAR > > > > SELECT count(*) > > INTO p_sip > > FROM b.CAR ------------------------> letak error > > WHERE IDPEL = NUMA > > AND EST = 'SIP02'; > > > > semoga membantu... > > guswi > > > > > > a_r_i_a <[EMAIL PROTECTED]> wrote: > > Para Master, > > > > Tolong donk. Saya punya schema a & b. > > Dischema a terdapat tabel REC dan di b terdapat table CAR. > > Ketika saya buat trigger didalam schema a table REC, terjadi error > > PLS-00201: identifier 'b.CAR' must be declared, trigger seperti dibawah > ini > > > > CREATE OR REPLACE TRIGGER "a".TR_SIP3_REC > > AFTER UPDATE OF EST_ACT ON REC > > FOR EACH ROW > > DECLARE > > p_sip numeric(1); > > > > BEGIN > > SELECT count(*) > > INTO p_sip > > FROM CAR ------------------------> letak error > > WHERE IDPEL = NUMA > > AND EST = 'SIP02'; > > END; > > / > > > > > > Mohon pencerahanya > > > > Regards, > > Aria > > > > > > -- > > -----------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 > > > > > > > > SPONSORED LINKS > > Database development software Database management software Database > software > > Inventory database software Membership database software Citrix terminal > > server > > > > --------------------------------- > > YAHOO! GROUPS LINKS > > > > > > Visit your group "indo-oracle" on the web. > > > > To unsubscribe from this group, send an email to: > > [EMAIL PROTECTED] > > > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > > > > --------------------------------- > > > > > > > > > > --------------------------------- > > Yahoo! Sports > > Rekindle the Rivalries. Sign up for Fantasy Football > > > > [Non-text portions of this message have been removed] > > > > > > > > -- > > -----------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 > > > > > > > > > > > > > > > > > -- > -----------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 > > > Visit your group "indo-oracle" on the web. > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > --------------------------------- > > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > [Non-text portions of this message have been removed] > > > > -- > -----------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 > > > > > > > -- -----------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/
