Security and users access to Oracle

Question

Hi Gurus,

can you please assist in what best practices available to control the below points in Oracle fusion, and is there any report from Oracle that show last activity for any user for monitoring purpose.

Point 1

Administrators users changes to the system full report

Point 2

Monitoring user access rights and the activities of the privileged accounts

Nathan CCC · Answer

Hi Sidney,

If you look at your session log of the query proposed by Rebecca

select all 0 s_0, "User"."Last Activity Date" as s from "User System Usage"

you can see that the data source is this database table column

select all t.last_activity_date as s from fnd_session_users t

If you get no data then that is likely that there is no data in the table because audit of what timestamp a user sign in is turned off by default. you have to set a parameter to turn it on.

Select Navigator, select Show More

In group My Enterprise select work area Setup and Maintenance

Select task Manage Administrator Profile Values

Profile Option Code = FND_TRACK_USER_ACTIVITY

update Profile Level = Site value from DISABLED to ENABLED

For more information see

https://docs.oracle.com/en/cloud/saas/sales/facaa/set-up-adoption-and-usage-tracking.html#s20074568

Rebecca Hawker · Answer

Hi

Perhaps check out the User System Usage subject area for Last Activity Date against a Users Profile, and also for Administrators enable this:

You can get the last seven days of user sign-in sign-out information.

Regards Rebecca

Sidney Mori · Answer

Hi, I try to use this subjects areas,but i can´t found la last conection of the users, Do you Know about That?

Thanks

Sidney