Home » RDBMS Server » Security » prevent database user to connect by specified program
prevent database user to connect by specified program [message #121946] Wed, 01 June 2005 18:39 Go to next message
mostafa71
Messages: 18
Registered: May 2005
Junior Member

hi
Is it possible to prevent specified database user to logon by specified program ?
if it is possible how can i do it ?

regards
Re: prevent database user to connect by specified program [message #121968 is a reply to message #121946] Thu, 02 June 2005 02:00 Go to previous messageGo to next message
Frank Naude
Messages: 4565
Registered: April 1998
Senior Member
Hi,

You can create a "AFTER LOGON" trigger to check the program and reject the connection if the user is using a certain program. However, nothing prevents the user from renaming the program.

Look at the example at http://www.orafaq.com/scripts/security/notoad.txt

Best regards.

Frank
Re: prevent database user to connect by specified program [message #122016 is a reply to message #121946] Thu, 02 June 2005 06:56 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
What if I rename my TOAD? There have been quite some discussions about this very subject, also at AskTom. Check this thread.


HTH,
MHE
Previous Topic: PL/SQL code for a login/password feature
Next Topic: passwd changed
Goto Forum:
  


Current Time: Mon Aug 03 16:23:19 CDT 2020