Аудит доступа к 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;