OraFAQ Forum: Security » Disconnect from oracle DB.

Home » RDBMS Server » Security » Disconnect from oracle DB. (Oracle 9i, Win 2000 - SP4)

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

Disconnect from oracle DB. [message #466847]

Wed, 21 July 2010 08:49

SAKOURA
Messages: 52
Registered: June 2010
Location: France

Member

Hi everybody,

Is there any setting on oracle that allows to disconnect users automatically and display a message to users such: "Try a new connection to the db in 30 minutes"?

Thanks in advance for your help.
Sak.

Report message to a moderator

Re: Disconnect from oracle DB. [message #466864 is a reply to message #466847]

Wed, 21 July 2010 09:27

Michel Cadot
Messages: 68756
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

To disconnect automatically, yes, use a profile.
To display a message, no, Oracle does not display anything, its client program does, so it's up to you to program it to display a message.

Regards
Michel

Report message to a moderator

Re: Disconnect from oracle DB. [message #466872 is a reply to message #466847]

Wed, 21 July 2010 09:41

SAKOURA
Messages: 52
Registered: June 2010
Location: France

Member

Hi Michel,
According to your link a profile allows many things among them: "•Amount of idle time available for the user's session"
Does it mean that a user is disconnected if he is not using the db?
Thx in advance.
Sak.

Report message to a moderator

Re: Disconnect from oracle DB. [message #466881 is a reply to message #466872]

Wed, 21 July 2010 10:38

Michel Cadot
Messages: 68756
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes.

regards
Michel

Report message to a moderator

Re: Disconnect from oracle DB. [message #467033 is a reply to message #466881]

Thu, 22 July 2010 01:33

SAKOURA
Messages: 52
Registered: June 2010
Location: France

Member

Hi Michel,
I found the following command: "create profile appl_profile limit idle_time 15 -- minutes".
Should I run it for under a connection with my db user or the user Sys (or System) or another one?
Thanks in advance for your help.
Sak.

Report message to a moderator

Re: Disconnect from oracle DB. [message #467035 is a reply to message #467033]

Thu, 22 July 2010 01:49

Michel Cadot
Messages: 68756
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

With a DBA account, you create the profile then you assign it to the user using ALTER USER command.

Regards
Michel

Report message to a moderator

Re: Disconnect from oracle DB. [message #467073 is a reply to message #466847]

Thu, 22 July 2010 03:58

SAKOURA
Messages: 52
Registered: June 2010
Location: France

Member

Well, I did ...
I create a new profile (disconnection after 5') with a DBA account then I assigned it to my db user. Next step was a connection to the db through my software and ... nothing happened: After 5, 10, 15'... I could insert infos in the db tables !
Had I forget something? Is there another setting?
Thx in advance for your replies!
Sak.

Report message to a moderator

Re: Disconnect from oracle DB. [message #467125 is a reply to message #467073]

Thu, 22 July 2010 05:10

Michel Cadot
Messages: 68756
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

nothing happened

Had you a look to session status in v$session? The session is killed (SNIPED) but you have nothing on your interface as it is your turn to talk to Oracle and it is waiting for you to ask it to do something to tell you that you have been disconnected.

Regards
Michel

Report message to a moderator

Previous Topic:	Resarch by title "securing oracl database from search engine attack"
Next Topic:	ORA-01031:insufficient privileges,I already checked the other threads about this, still doesn't work

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 07 13:32:30 CDT 2025