Home » RDBMS Server » Server Administration » LOCK USER AT A SPECIFIC DATE (11G R2, WINDOW 7)
LOCK USER AT A SPECIFIC DATE [message #675301] Thu, 21 March 2019 12:13 Go to next message
kilimanjaro
Messages: 150
Registered: May 2009
Location: Tanzania
Senior Member
How to set the user account LOCK AT A SPECIFIC date in ORACLE?
THANK YOU.

Re: LOCK USER AT A SPECIFIC DATE [message #675303 is a reply to message #675301] Thu, 21 March 2019 12:19 Go to previous messageGo to next message
Michel Cadot
Messages: 66679
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Create a job for this.

Re: LOCK USER AT A SPECIFIC DATE [message #675319 is a reply to message #675303] Fri, 22 March 2019 01:54 Go to previous messageGo to next message
kilimanjaro
Messages: 150
Registered: May 2009
Location: Tanzania
Senior Member
Thank you
but how do I do that Chief?
Re: LOCK USER AT A SPECIFIC DATE [message #675321 is a reply to message #675319] Fri, 22 March 2019 02:03 Go to previous messageGo to next message
Michel Cadot
Messages: 66679
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

DBMS_JOB or DBMS_SCHEDULER.

Re: LOCK USER AT A SPECIFIC DATE [message #675322 is a reply to message #675321] Fri, 22 March 2019 02:04 Go to previous message
Michel Cadot
Messages: 66679
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Or Windows Task Scheduler

Previous Topic: Corrupted index causing data-integrity issues
Next Topic: CREATE PLUGGABLE DATABASE fails
Goto Forum:
  


Current Time: Mon Nov 11 23:40:47 CST 2019