Документ создан: 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;
 
Recent changes RSS feed Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki Donate