All

I've received a query from a user who wants to know about Discoverer login details - the last time people have logged on etc...

I've searched high and low and can't find any core tables where this information is stored (unlike apps login info which is stored in the FND_USER table)

Any help on where this information is stored (if anywhere!) would be greatly appreciated.

Many thanks
Jon

Jon
I'll inquire of the 3 'disco' experts that i sit opposite when I get back into the office tomorrow.

Regards
Barry

Thanks Barry

Jon
Looking at the environment that i have access to, there are 3 schema's of interest...
DISCO, EUL4_US and EUL_OWNER_US

In the DISCO schema there is a table called PTG_SESSION_LOG which has columns such as USER_ID, LOGIN_TIME, LOGIN_HOUR etc.

The EUL_OWNER_US schema has tables EUL4_EUL_USERS and EUL5_EUL_USERS.

Not sure if any of this is of use.

Cheers
Barry

Thank You!

The only schema on my environment is EUL4_US - like you say, the table EUL4_EUL_USERS contains lots of the information I am after. Think I was thrown by the name!

I will have a look round to see what other relevant information is in this schema. If I find anything I will add a new post to share it with everyone.

Cheers for your help Barry, much appreciated.