usere level info.

Database
Enthusiast

usere level info.

Hi All,

I need to fetch out information from system table,which will give me information that who all users logged in system and what all activity they performend including SQL statement and what was the session duration.

It's urgent requirement.
Plz. help.

Regards,
gander_ss
1 REPLY
Enthusiast

Re: usere level info.

u can check the currently connected user information from dbc.sessioninfo
and all the users information from dbc.qrylog table.

Thanks,
Mahesh