OraFAQ Forum: Security » prevent database user to connect by specified program

Home » RDBMS Server » Security » prevent database user to connect by specified program

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

prevent database user to connect by specified program [message #121946]

Wed, 01 June 2005 18:39

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

Report message to a moderator

Re: prevent database user to connect by specified program [message #121968 is a reply to message #121946]

Thu, 02 June 2005 02:00

Frank Naude
Messages: 4587
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

Report message to a moderator

Re: prevent database user to connect by specified program [message #122016 is a reply to message #121946]

Thu, 02 June 2005 06:56

Maaher
Messages: 7065
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

Report message to a moderator

Previous Topic:	PL/SQL code for a login/password feature
Next Topic:	passwd changed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 23 13:15:55 CST 2025