Документ создан: 17.02.2010

Аудит доступа к SSO

Интересные запросы из базы.

SELECT USER_NAME
       ||' - '
       ||MESSAGE
       ||' - '
       ||to_char(LOG_DATE,'dd.mm.yyyy hh24:mi:ss')
       ||' - '
       ||IP_ADDRESS "Today's Failures"
FROM ORASSO.WWSSO_AUDIT_LOG_TABLE$
WHERE to_char(LOG_DATE,'dd.mm.yyyy') = '16.02.2010'
  AND MESSAGE = 'Login Successful';
SELECT count (*) count,
       USER_NAME
FROM ORASSO.WWSSO_AUDIT_LOG_TABLE$
WHERE to_char(LOG_DATE,'dd.mm.yyyy') = '17.02.2010'
  AND MESSAGE = 'Login Successful'
GROUP BY USER_NAME, ip_address
ORDER BY count DESC;
 
Top.Mail.Ru
Recent changes RSS feed Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki Donate