OraFAQ Forum: Security » Limit access to user

Home » RDBMS Server » Security » Limit access to user (Oracle 10g / Windows)

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

Limit access to user [message #519737]

Tue, 16 August 2011 10:39

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.

Report message to a moderator

Re: Limit access to user [message #519739 is a reply to message #519737]

Tue, 16 August 2011 10:42

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

You don't state what Oracle version. However, look up LOGON TRIGGER in the Oracle documentation.

HTH
-g

Report message to a moderator

Re: Limit access to user [message #519740 is a reply to message #519737]

Tue, 16 August 2011 10:43

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Limit access to user [message #519747 is a reply to message #519737]

Tue, 16 August 2011 11:09

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Previous Topic:	user creation
Next Topic:	oracle 10g security for developer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 27 09:41:49 CST 2025