Mas Yoel, sarannya berhasil. thanks ya Henry ----- Original Message ----- From: H Gunawan To: [email protected] Sent: Wednesday, May 13, 2009 6:47 AM Subject: Re: [indo-oracle] Insufficient priviledge untuk view
ok saya coba ya, thanks Henry ----- Original Message ----- From: Yoel Susanto To: [email protected] Sent: Wednesday, May 13, 2009 12:59 AM Subject: Re: [indo-oracle] Insufficient priviledge untuk view Hi Henry, lakukan grant select on schema02.tableXYZ to schema01 WITH GRANT OPTION; grant select on schema01.view01 to user01; Coba deh. Cheers, Yoel Susanto www.indo-oracletech.com 2009/5/13 H Gunawan <[email protected]> > > > Hi Master, > mau nanya nich, saya punya satu user User01, lalu saya punya 2 schema lain, > Schema01 dan Schema02. > Di Schema01 ada View01 yang select ke table Schema02.TableXYZ. > > Lalu saya Grant Select on View01 to User01. > Waktu saya cek di EM, object itu sudah tergrant dengan baik. Tapi ketika > dicoba select dari schema User01, saya dapat error Insufficient Priviledge. > Lalu saya coba juga untuk grant select TableXYZ langsung ke User01. > > Nah User01 ketika menjalankan sql query dari View01 alias menjalankan > perintah select langsung ke TableXYZ, berhasil sukses tidak ada error apa2. > Tapi ketika dicoba select dari View01, lagi2 dpt error Insufficient > Priviledge. > > Kira2 ada apa yang kurang ya? user ini sudah saya kasih quota unlimited > juga di tablespace. system priviledgenya cuman Create Session. > > thanks > Henry > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] ---------------------------------------------------------- No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.176 / Virus Database: 270.12.27/2111 - Release Date: 5/12/2009 6:03 PM [Non-text portions of this message have been removed] ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.176 / Virus Database: 270.12.27/2111 - Release Date: 5/12/2009 6:03 PM [Non-text portions of this message have been removed]
