dblink dari user A(X) dan tidak public. View 'test_v' sudah di grant
select ke B(X), dan 'test2_v' di grant select, insert, update, delete
ke B(X).
ketika dari B(X) dijalankan 'select * from test_v' sukses.
Juga saat 'insert into test2_v select * from test' juga sukses ('test'
adalah tabel yg dimiliki user C(X).
--- In [email protected], Leonard Sukendro <[EMAIL PROTECTED]>
wrote:
>
> klo boleh tau, dblink nya dibuat pake user apa? user
> A? dblink nya dbuat public gk ya?
>
> regards,
> [L]
>
> --- cyuniart <[EMAIL PROTECTED]> wrote:
>
> > Dear all,
> > Mohon bantuannya,
> >
> > ada 3 DB (X, Y, Z)
> >
> > dari user A di DB X dgn memakai dblink saya membuat
> > view 'test_v'
> > untuk tabel yang ada di DB Y dan view 'test2_v'
> > untuk tabel di DB Z.
> >
> > ketika saya coba insert dari user B(X)
> >
> > insert into test_v
> > select * from test2_v
> >
> > muncul error
> >
> > ORA-02019: connection description for remote
> > database not found
> > ORA-02063: preceding line from X
> > ORA-02063: preceding 2 lines from Z
> >
> > tapi saat perintah itu dijalankan di user A (X),
> > ternyata sukses.
> > padahal synonym dan grant yg diperlukan oleh B(X)
> > sudah diberikan.
> >
> > mohon bantuannya,
> > o ya, saya memakai oracle 10g rilis 1.
> >
> > Thx sebelumnya,
> > tjhondro
> >
> >
> >
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Something is new at Yahoo! Groups. Check out the enhanced email design.
http://us.click.yahoo.com/SISQkA/gOaOAA/yQLSAA/PhFolB/TM
--------------------------------------------------------------------~->
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
Mirror: http://indooracle.wordpress.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.blogspot.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/
