Home » RDBMS Server » Security » oracle account limitation (9.2.0.7.0)
oracle account limitation [message #528462] Tue, 25 October 2011 02:20 Go to next message
piotrtal
Messages: 168
Registered: June 2011
Location: Poland/Czestochowa
Senior Member
hi.

there is urge to limit account usability in oracle.
let's say i have request to create user HR1, and additional information is that this account should be available for using till 31-dec-2011.
is there posibility to set this validity during creation? - any ways...?

or only additional packages/procedures made by myself can deal with this?

thank.s

Report message to a moderator

Re: oracle account limitation [message #528464 is a reply to message #528462] Tue, 25 October 2011 02:54 Go to previous message
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
is there posibility to set this validity during creation? - any ways...?

Not native but you can create a job that will drop or lock this account at this time.

Regards
Michel

Report message to a moderator

Previous Topic: errors in running pupbld.sql script (2 Merged)
Next Topic: Automating Password Changes
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 30 13:43:33 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.