Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Where can i check the last login date time for user in read only mode Data Guard?

User_SZR3UMay 3 2023

We have Read Only mode Data Guard implemented in our Production environment. Some users are only allow to read data from Data Guard. They never login Primary environment. As i know, the information in “dba_users” are only sync from Primary. Therefore, i was unable to check the last login date time from “dba_users” in Date Guard. Would like to know is there any system table/view i can check the last login date time in Data Guard.

Thank you.

Comments
Post Details
Added on May 3 2023
0 comments
611 views