how to disable TOAD on a database

greenspun.com : 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 (antos@vsnl.net), June 25, 2004

Answers

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

Regards,

Evan Vinck

-- Evan Vinck (evan_vinck@hotmail.com), August 06, 2004.


Moderation questions? read the FAQ