Home » RDBMS Server » Security » Limit access to user (Oracle 10g / Windows)
Limit access to user [message #519737] Tue, 16 August 2011 10:39 Go to next message
Karlia
Messages: 40
Registered: May 2011
Location: Algiers
Member
Hello every body,

is there any way to prevent user to acces via some specefic programs ?
or to limit the set of programs (tools) that are allowed for user to connect the database ?


thanks.
Re: Limit access to user [message #519739 is a reply to message #519737] Tue, 16 August 2011 10:42 Go to previous messageGo to next message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, UK
Senior Member
You don't state what Oracle version. However, look up LOGON TRIGGER in the Oracle documentation.

HTH
-g
Re: Limit access to user [message #519740 is a reply to message #519737] Tue, 16 August 2011 10:43 Go to previous messageGo to next message
BlackSwan
Messages: 26538
Registered: January 2009
Location: SoCal
Senior Member
>is there any way to prevent user to acces via some specefic programs ?
no

>or to limit the set of programs (tools) that are allowed for user to connect the database ?
yes, have boss issue policy that says anyone caught using unauthorized software will be summarily terminated.
Re: Limit access to user [message #519747 is a reply to message #519737] Tue, 16 August 2011 11:09 Go to previous message
Mahesh Rajendran
Messages: 10690
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Best method is to make it a policy / do not install those tools.
The logon trigger can be easily bypassed by just renaming the
doNotAllowthisTool.exe to allowthis.exe in OS.
Previous Topic: user creation
Next Topic: oracle 10g security for developer
Goto Forum:
  


Current Time: Wed Jun 19 15:51:33 CDT 2019