How to query for users that have accessed a database in a time window?
Posted by: Stephen Kwok
Date: August 13, 2021 04:25PM

Hi,

I understand that there is the `show processlist` command to show the processes that are currently running by which users and the command the user is running, etc. Can someone please tell me how I can query for the users that have accessed a database in a window of time? e.g., last 7 days. Thanks.

Options: ReplyQuote


Subject
Written By
Posted
How to query for users that have accessed a database in a time window?
August 13, 2021 04:25PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.