how to disable TOAD on a database : LUSENET : DBAzine : One Thread

Hi There ,

Can anyone tell me how do I disable TOAD activity on a database ?

Thanks in Advance...

Anto Samson

-- Anto Samson (, June 25, 2004


You can do that with an afterlogon trigger. It can look in v$session at sid ,serial# and program, if the last is 'toad.exe' it should kill the session with 'alter system kill session'command.

Hope this helps


Evan Vinck

-- Evan Vinck (, August 06, 2004.

Moderation questions? read the FAQ