coba jawab yah setau saya untuk buat DB link kita harus autentikasi menggunakan username database yang di tuju
dalam hal ini dari serverB dblink ke serverA menggunakan user yang ada di serverA kalau yang di pakai UserA1 sebagai autentikasi dblink maka siapapun yang menggunakan dblink tersebut akan mendapat previledge user A tersebut (CMIIW) jadi tidak perlu memberi previledge ke user di serverB lagi, cuma beri previledge untuk menggunakan dblink tersebut saja. (CMIIW) 2009/9/8 OLA <[email protected]> > > > mas kalo seperti ini kasusnya bagaimana ?? > > Server = ServerA > username = UserA, UserA1 > > Role = Role_A (di grant table_A1, Table_A2, ...) > UserA1 diberi grant RoleA > > dan > > Server = ServerB > username = UserB. User_B1 > > Pada userB saya buat database link ke UserA1 > > pertanyaan saya adalah > Bagaimana cara memberi privilege dari Role_A ke user_B1 > > kepada para suhu mohon pencerahaannya ?? > > Ola Geulis > > ----- Original Message ----- > From: Mohammad Arief Pradipto > To: [email protected] <indo-oracle%40yahoogroups.com> > Sent: Monday, September 07, 2009 3:19 PM > Subject: Re: [indo-oracle] ??? Grant Privileges > > Kalau yang saya tangkep bener, maksudnya mbak ola mau melakukan hal hal > sesuai dengan role A dari Database B dengan menggunakan DBLink tersebut. > > Apabila DBLink tersebut dibuat dengan konek menggunakan user A, maka role A > bisa dijalankan dengan DBLink tersebut > > CMIIW > > regards, > > adipt > ----- Original Message ----- > From: OLA<mailto:[email protected] <stikom.bogor%40yahoo.co.id>> > To: [email protected] <indo-oracle%40yahoogroups.com><mailto: > [email protected] <indo-oracle%40yahoogroups.com>> > Sent: Monday, September 07, 2009 1:37 PM > Subject: [indo-oracle] ??? Grant Privileges > > Teman-teman aku minta tolong aku punya > Server = ServerA > username = UserA > Role = Role_A (di grant table_A1, Table_A2, ...) > > dan > > Server = ServerB > username = UserB. User_B1 > > Pada userB saya buat database link ke UserA > > pertanyaan saya adalah > Bagaimana cara memberi privilege dari Role_A ke user_B1 > > kepada para suhu mohon pencerahaannya ?? > > Ola Geulis > > [Non-text portions of this message have been removed] > > ________________________________ > This e-mail and any files transmitted with it are confidential and intended > solely for the use of the individual or entity to whom they are addressed. > If you have received this email by mistake please notify the sender by > return e-mail and delete this message from your system. Any unauthorized use > or dissemination of this e-mail in whole or in part is strictly prohibited. > PT Federal International Finance, which has its seat at North of Jakarta, > Indonesia, including its affiliated companies, shall not be liable for the > improper or incomplete transmission of the information contained in this > e-mail nor for any delay in its receipt or damage to your system. PT Federal > International Finance (or its affiliated companies) does not guarantee that > the integrity of this communication has been maintained nor that this > communication is free of viruses, interceptions or interference. > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > > -- silahkan kunjungi alamat berikut : http://irvan.site90.net http://www.suzuki-2wheels.or.id/forum [Non-text portions of this message have been removed]
