Enterprise Manager Generic (MOSC)

MOSC Banner

Metric extension to find db user password change dates

edited Jul 30, 2013 7:48AM in Enterprise Manager Generic (MOSC) 1 commentAnswered
We'd like to report database user accounts that haven't changed their passwords over a particular duration.  The default dataset collected in sysman.mgmt$db_users does not contain that particular information
CREATE OR REPLACE VIEW sysman.mgmt$db_users AS
  SELECT g.host_name,
s.target_name,
s.target_type,
s.target_guid,
s.start_timestamp AS collection_timestamp,
a.username,
a.user_id,
a.default_tablespace,
a.temporary_tablespace,
a.created,
a.profile,
a.expiry_date
 FROM mgmt_targets g,
mgmt_db_users_ecm a,
gc$ecm_gen_snapshot s
 WHERE s.snapshot_guid = a.ecm_snapshot_id
 AND    s.target_guid = g.target_guid

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