Security and users access to Oracle

Wael.Dawood-Oracle

 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

Hi,

1.

In OTBI you have subject areas

• "User System Usage"
• "Security - Roles and Privileges Real Time"
• "Security - Audit Real Time"
• "OTBI Usage Real Time"
• "OTBI Performance Real Time"

2.

Also have you considered as solution to your use case using application "Risk Management and Compliance". This is one of the applications the suite of applications in Oracle Fusion Cloud Applications. See https://docs.oracle.com/en/cloud/saas/risk-management-and-compliance/24a/index.html

Sidney Mori

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

Rebecca Hawker

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

Nathan CCC

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