Database Security Products (MOSC)

MOSC Banner

How to identify unused or expired DBMS accounts?

edited Oct 8, 2009 7:08PM in Database Security Products (MOSC) 10 commentsAnswered
  To maintain security and avoid unauthorized access to database I need to identify unused or expired DBMS accounts. I need to monitor DBMS accounts with DEFAULT profile and if they are inactive for 30 days I need to print the list of them. Then I will need to lock and to expire them and consider dropping them after receiving authorization from applications' administrators. Can you suggest the best approach? I would like to have a script (or sequence of scripts/steps) that could eventually print for me the list of these suspicious accounts.
Victor

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center