Using the SSO Audit Log Table

There is an important log tables inside the iasdb instance in the orasso schema called
wsso_audit_log_table_t  that you can use to extract SSO interaction information.  This table contain many detailed metrics about SSO interaction:

SQL> desc ORASSO.WWSSO_AUDIT_LOG_TABLE_T;

Name                          Null?    Type
 ----------------------------- -------- --------------------
 SUBSCRIBER_ID                 NOT NULL NUMBER
 LOG_ID                        NOT NULL NUMBER
 USER_NAME                     NOT NULL VARCHAR2(256)
 AUDIT_TYPE                    NOT NULL VARCHAR2(32)
 ACTION_CODE                   NOT NULL NUMBER
 ACTION                        NOT NULL VARCHAR2(80)
 IP_ADDRESS                    NOT NULL VARCHAR2(32)
 APP_SITE                      NOT NULL VARCHAR2(80)
 MESSAGE                       NOT NULL VARCHAR2(256)
 LOG_DATE                      NOT NULL DATE
 PROCESS_DATE                           DATE
 EMAIL                                  VARCHAR2(80)
 MAINTAINER_ID                          VARCHAR2(80)

We can take the data from this table and create SSO summary report for execution in SQL*Plus.  Below we see a common SSO activity report:

 

Read more here:

http://www.dba-oracle.com/application_server/t_app_server_sso.htm

 

*****************************************

Need Oracle Training?

The very best Oracle training comes from Burleson Consulting, where you get an on-site visit by an experienced Oracle expert and author.  Whether it's one-on-one mentoring or getting a customized on-site Oracle training class, there is no substitute for BC Oracle training. 

Just call 800-766-1884 for details, and check-out our on-site Oracle training catalog at the following link:

http://www.dba-oracle.com/bc-catalog.pdf