Wednesday, September 27, 2006

Check account status on Oracle 10g

How to check your DB account status? Is it locked? Here is the SQL to be used:


SELECT USERNAME, PROFILE, ACCOUNT_STATUS, password FROM DBA_USERS
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)