Mas Juanda, Karena V_$SQL_PLAN_TO milik SYS bukan SYSTEM. Jadi yang berhak memberikan grant ke user lain adalah sang pemiliknya, yaitu SYS.
Cheers, Wadi Achmed On Mon, Jan 4, 2010 at 8:12 PM, juanda hakim <[email protected]> wrote: > Mas yuliiuuuuuuuuuuuuus,,,,, > g bisa mas,,, > > udah dicoba > > SQL> CONN SYSTEM > Enter password: ****** > Connected. > SQL> GRANT SELECT ON V$SQL_PLAN TO COBA; > GRANT SELECT ON V$SQL_PLAN TO COBA > * > ERROR at line 1: > ORA-01031: insufficient privileges > > ============================================= > SQL> CONN SYS AS SYSDBA > Enter password: ****** > Connected. > SQL> GRANT SELECT ON V$SQL_PLAN TO COBA; > GRANT SELECT ON V$SQL_PLAN TO COBA > * > ERROR at line 1: > ORA-02030: can only select from fixed tables/views > ============================================= > > tapi tadi saya iseng2 masuk sebagai sys, trus saya create procudure dari > tabel V$SQL_PLAN > alhasil,,,sukses maaaaas,,,,, > > tapi begitu saya masuk sebagai system, kenapa g bisa??? > duuuh makin bingung mas,,,, > mohon petunjuknya ,,,, > > > > > > Lebih aman saat online. Upgrade ke Internet Explorer 8 baru dan lebih > cepat yang dioptimalkan untuk Yahoo! agar Anda merasa lebih aman. Gratis. > Dapatkan IE8 di sini! > http://downloads.yahoo.com/id/internetexplorer/ > > [Non-text portions of this message have been removed] > > > > ------------------------------------ > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [email protected] > Website: http://indooracle.wordpress.com > http://www.facebook.com/group.php?gid=51973053515 > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.blogspot.comYahoo! Groups Links > > > > [Non-text portions of this message have been removed]
