Last Successful Login Time in SQL*Plus
No Oracle Database 12c, foi introduzida uma nova funcionalidade no utilitário SQLPlus, o Last Successful Login Time in SQLPlus.
O SQL*Plus do Oracle Database 12c adicionou uma informação na tela login, agora por default, é mostrada a última data e hora de login do usuário.
[oracle@oracle01]$ sqlplus scott/tiger
SQL*Plus: Release 12.1.0.1.0 Production on Thu Mar 27 16:23:55 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Last Successful login time: Wed Mar 26 2014 16:02:23 +01:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
Essa informação também pode ser obtida na viewDBA_USERS:
SQL> select username,last_login
from dba_users
where username = 'SCOTT';
USERNAMELAST_LOGIN
--------------- -------------------------
SCOTT27.03.2014 16:23:56
Para inibir isso, basta utilizar a opção nologintime:
[oracle@oracle01 tmp]$ sqlplus -nologintime scott/tiger
SQL*Plus: Release 12.1.0.1.0 Production on Thu Mar 27 16:26:40 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
SQL>
Referências
Abraço