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: 151
Registered: May 2009
Location: Tanzania
Senior Member
How to set the user account LOCK AT A SPECIFIC date in ORACLE?
THANK YOU.

Report message to a moderator

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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Create a job for this.

Report message to a moderator

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: 151
Registered: May 2009
Location: Tanzania
Senior Member
Thank you
but how do I do that Chief?

Report message to a moderator

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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

DBMS_JOB or DBMS_SCHEDULER.

Report message to a moderator

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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Or Windows Task Scheduler

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 28 08:44:57 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.