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] 
  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]>
  To: [email protected]<mailto:[email protected]>
  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]

Kirim email ke