Home » RDBMS Server » Security » Disconnect from oracle DB. (Oracle 9i, Win 2000 - SP4)
Disconnect from oracle DB. [message #466847] Wed, 21 July 2010 08:49 Go to next message
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.
Re: Disconnect from oracle DB. [message #466864 is a reply to message #466847] Wed, 21 July 2010 09:27 Go to previous messageGo to next message
Michel Cadot
Messages: 66936
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Disconnect from oracle DB. [message #466872 is a reply to message #466847] Wed, 21 July 2010 09:41 Go to previous messageGo to next message
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.
Re: Disconnect from oracle DB. [message #466881 is a reply to message #466872] Wed, 21 July 2010 10:38 Go to previous messageGo to next message
Michel Cadot
Messages: 66936
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

regards
Michel
Re: Disconnect from oracle DB. [message #467033 is a reply to message #466881] Thu, 22 July 2010 01:33 Go to previous messageGo to next message
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.
Re: Disconnect from oracle DB. [message #467035 is a reply to message #467033] Thu, 22 July 2010 01:49 Go to previous messageGo to next message
Michel Cadot
Messages: 66936
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Disconnect from oracle DB. [message #467073 is a reply to message #466847] Thu, 22 July 2010 03:58 Go to previous messageGo to next message
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.
Re: Disconnect from oracle DB. [message #467125 is a reply to message #467073] Thu, 22 July 2010 05:10 Go to previous message
Michel Cadot
Messages: 66936
Registered: March 2007
Location: Nanterre, France, http://...
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
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:
  


Current Time: Tue Apr 07 13:03:56 CDT 2020