sql - ORACLE Managing Locked Accounts -


ok i'm doing course in oracle , got question part of project. know system table can query following information.

the utility should able identify each locked account locked because of invalid login attempts. utility should further unlock accounts have been locked more week.

i know dba_users shows locked accounts show why account locked. can't use identify if there locked case of invalid login attempts.

also know how unlock them.

have @ column: account_status (in dba_users).
surprisingly - information of reason lock there...

http://docs.oracle.com/cd/e11882_01/server.112/e40402/statviews_5081.htm#refrn23302


Comments

Popular posts from this blog

PHPMotion implementation - URL based videos (Hosted on separate location) -

javascript - Using Windows Media Player as video fallback for video tag -

c# - Unity IoC Lifetime per HttpRequest for UserStore -