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: 152
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
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: 59414
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: errors in running pupbld.sql script (2 Merged)
Next Topic: Automating Password Changes
Goto Forum:
  


Current Time: Tue Oct 21 22:47:12 CDT 2014

Total time taken to generate the page: 0.07267 seconds