lock_date

When I query for lock_date my out put is like this..
can you tell me what does this means..

SQL> select lock_date from dba_users;

LOCK_DATE
---------






26-MAR-11
26-MAR-11
26-MAR-11
26-MAR-11
26-MAR-11

LOCK_DATE
---------
26-MAR-11
26-MAR-11
26-MAR-11
26-MAR-11
26-MAR-11
26-MAR-11
26-MAR-11
26-MAR-11
26-MAR-11
26-MAR-11
26-MAR-11

LOCK_DATE
---------
26-MAR-11
26-MAR-11
26-MAR-11
26-MAR-11
26-MAR-11
26-MAR-11
15-OCT-07
26-MAR-11
26-MAR-11
26-MAR-11

32 rows selected.

SQL>




nobleitAsked:
Who is Participating?
 
PilouteCommented:
@nobleit

PLEASE read the oracle docs. Start with the Concepts doc (http://download.oracle.com/docs/cd/E11882_01/server.112/e16508/toc.htm) . You really need to understand what oracle is and how it works.

>> who created that lock <<

Nobody. And 'that lock' is not an object or a fact but a flag that means the account is locked (it can not be used to log in). The database you have 'created' is in fact a copy of a template where those accounts are just locked. That's all.

Cheers,
P
0
 
slightwv (䄆 Netminder) Commented:
That is the date the account was locked.

The docs, check the docs for explanation of the columns in the database views/tables.
0
 
sdstuberCommented:
locking occurs typically because of password expiration or multiple failed login attempts - both controlled by user policies

accounts can also be locked explicitly
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
nobleitAuthor Commented:
I recently created the database..
then how the account is locked on 15-OCT-07
 in the query...
0
 
slightwv (䄆 Netminder) Commented:
How did you create the database?  If from templates, it is basically a 'copy' of a precreated database.
0
 
nobleitAuthor Commented:
from template..couple of months back..
0
 
slightwv (䄆 Netminder) Commented:
There you go.
0
 
nobleitAuthor Commented:
who created that lock.
0
 
sdstuberCommented:
wasn't a split in order?
0
 
slightwv (䄆 Netminder) Commented:
I agree.  I don't see where the accepted answer did anything I didn't already provide except a doc link.  I'll give it partial credit for explaining the 'accounts cam locked from the template'.  I thought that was sort of self-explanatory based on the previous comments.


nobleit,

Please explain why you accepted the post you did.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.