Database Reference
In-Depth Information
EDITIONS_ENABLED VARCHAR2(1)
AUTHENTICATION_TYPE VARCHAR2(8)
PROXY_ONLY_CONNECT VARCHAR2(1)
COMMON VARCHAR2(3)
LAST_LOGIN TIMESTAMP(9) WITH TIME ZONE
ORACLE_MAINTAINED VARCHAR2(1)
So
last_login
finally saves the day. When you create low-privileged DBA accounts for the DBA team and they
have not used them for the past month, you can safely say that either the DBAs are doing no work or they are still
logging in with the OSDBA accounts to do their
SELECT
queries. We all like to save time, but the
LAST_LOGIN
column's
added transparency will encourage low-priv account usage and probably save a million fat thumbs in future, so good
work Oracle. It should also be said that a lot of user management work has been pushed to EM12c so that a DBA can
easily manage privileges and roles within groups of servers with a few clicks. EM12c is the way forward, but it has been
handy to be able to go to
SQL*PLUS
and fix things directly if necessary. For security purposes, good command-line
skills are a pre-requisite.
There are additional 12c-specific user management commands listed in Chapter 7 in the
“
Pluggable Database
primer.
” The next chapter looks at how to vulnerability-scan a database using Perl.
