pandu, thanks atas another idea and invite nya :)
saya coba utak-atik PRODUCT_USER_PROFILE (PUP) table , berdasarkan url ini http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14357/ch9.htm so sqlplus bisa diblock pada statement level. ada advice lain? regards --ujang http://blog.faaza.info ----- Original Message ----- From: "Pandu W Perwira" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, March 13, 2006 9:17 PM Subject: Re: [indo-oracle] trigger after logon and audit > eh jang, gw ada alternatif lain ni (ide terakhir dari gw) user gak perlu > diskonek hanya saja dia gak bisa ngapa2in termasuk select (bahkan "select > * from tab"), idenya adalah menggunakan resource manager. > > jadi scriptnya triggernya ntar jadi gini : > > create or replace trigger tes_logon after logon on database > declare > v_yuhu varchar2(30); > begin > select nvl(module,'@@9@@') into v_yuhu > from v$session where audsid = sys_context('USERENV', 'SESSIONID') and > rownum<=1; > ignite; > if v_yuhu != '@@9@@' then > > dbms_Resource_manager.SWITCH_CONSUMER_GROUP_FOR_SESS(v_id,v_ser,'DEAD_GROUP'); > end if; > end; > / > > intinya adalah membuat grup buangan gw namain DEAD_GROUP, jadi user2 yang > nggak beres sesinya dibuang kesitu, nah untuk membuat group ini rada > banyak step2nya, kalo lo berminat japri aja ke imel gw atau YMan ajah ntar > gw kasih tau. > > btw ini gak ngaruh clientnya mau pake program apa aja bakal kena block > (dijamin 99% kecuali tuhan berkehandak lain) heheh =p > > salam > Send instant messages to your online friends http://asia.messenger.yahoo.com -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.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/
