August 1, 2013 archive

12c DBA_USERS Changes

Today, I was looking at the ability to query a user’s last login time. Prior to 12c, one had to create a logon trigger to store the logon time in a table or set up auditing and audit successful logins. Now, Oracle 12c includes, by default, a way to determine the last time someone logged …

Continue reading