Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Security User Access Report for Oracle Fusion instance
Organization Name
PricewaterhouseCoopers LLP
Description
Hi Team,
We are looking for report to find out the login/logout information of all the users who are accessing the Oracle fusion instance.
Please provide the security audit report with information like user name , user id , person number , person name , ;ogin time, logout time etc.
Regards
Prathy
Use Case and Business Need
This report will be used for security purposes to audit the login and logout information of all users who are accessing the fusion instance. It's will keep track of all users information with date and time stamp when they login/logout of instance.
More details
There is no delivered report for user login/logout information and the SR engineer has confirmed that don't use any tables like FNS_SESSIONS or ASE_USER_LOGIN_INFO tables to build any BIP report as the data in these tables are not reliable.
Original Idea Number: 12bf90f839
Comments
-
Regarding this request in the context of Oracle Analytics Cloud:
Oracle Analytics Cloud allows admins to track user activity and system usage to improve performance.
- OAC 5.3 Update: OAC & BI Publisher Audit and Report Usage: https://www.youtube.com/watch?v=sz1adkh-Y5o&t=63s
Oracle Analytics keeps track of all user transactions in an audit trail for optimal governance within one unified platform.
• Security Events Logging/Audit Trail: protection of the log files is based on OS file security; failed logon attempts are tracked in the log files and authentication and authorization events are captured in the log files as well.
• To protect the logs against tampering, the audit information is logged to a database and fully leverages database security.Oracle Analytics enables administrators to track usage at the user and system level across analytics assets so they can easily fine-tune performance for the analytics experience.
Some of the information tracked includes:
• Usage tracking logs all user data access including user identity, queries, timestamps, and the report/dashboard/analysis that were used.
• This information is available in a set of predefined dashboards that provide an audit trail of analytics usage. This tracking is also used by the platform's own performance optimization algorithms to recommend and create aggregate tables to improve performance.
• Metadata can be checked into a source code control system to track authorizations available for any specific date.- OAC 5.2 Update: Enabling Usage Tracking on OAC: https://www.youtube.com/watch?v=Sy9F7ozC3VI&t=220s
With Basic Usage Tracking users can see in real-time:
- # of logical queries in a project
- # of Physical Queries
- # of sessions
- Average Response Time
- # of Sessions
- # of logical queries by Start Date
- # of logical queries by Subject area name
- # of logical queries by Presentation name
Data Objects report canvas tab will show:
- top dashboard accessed by user
- top subject areas used by user
- Top data objects, dimensions, and metrics generated by user
you can also see the actual query used and the language of the query
0
