View Single Post
  #2 (permalink)  
Old November 8th, 2007, 06:13
oliver oliver is offline
Junior Member
 
Join Date: Jun 2007
Posts: 21
Thanks: 0
Thanked 5 Times in 5 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
oliver is on a distinguished road
Re: Login Information

I think that this information is part of either the App or Web-Server. In OTM you can have a look at GL_USER, but its per user so you would need to write your own summary-qry. Table :


GL_USER_GID VARCHAR2(12NOT NULL GL_USER_XID VARCHAR2(50)NOT NULL GL_PASSWORDVARCHAR2(12NOT NULL DOMAIN_NAMEVARCHAR2(50)NOT NULL IS_AD_HOC_REPORTS_USERVARCHAR2(1)NOT NULL Y/N LAST_LOGIN_DATEDATE AD_HOC_REPORTS_DB_TYPEVARCHAR2(100) OLTP/ODS GL_ACCOUNT_POLICY_GID (FK: GL_ACCOUNT_POLICY)VARCHAR2(101) PW_EXPIRATION_DATE DATE ACCOUNT_LOCKOUT_TIME DATE USERNAMEVARCHAR2(101) UNIQUE DEFAULT_USER_ROLE_GID (FK: USER_ROLE)VARCHAR2(101)NOT NULL IS_ADVANCED_ANALYTICS_USERVARCHAR2(1)NOT NULL Y/N DEFAULT_AA_REPORTVARCHAR2(100) DOCUMENT_USE_PROFILE_GID (FK: DOCUMENT_USE_PROFILE)VARCHAR2(101) INSERT_USERVARCHAR2(12NOT NULL INSERT_DATEDATENOT NULL UPDATE_USERVARCHAR2(12 UPDATE_DATEDATE
Reply With Quote
The Following User Says Thank You to oliver For This Useful Post:
moshe (November 8th, 2007)