IT Security Manager

Code Name

ORA_FND_IT_SECURITY_MANAGER_JOB

Duty Roles

This job role is related to the following duty roles:

• OTBI Report Performance Transactional Analysis Duty

• OTBI Report Usage Transactional Analysis Duty

• Security Transaction Analysis Duty

Subject Areas

This job role secures access to the following subject areas:

• OTBI Performance Real Time

• OTBI Usage Real Time

• Security - Audit Real Time

• Security - Roles and Privileges Real Time

Business Questions

This job role secures access to data that can answer the following business questions:

• Who are the top N OTBI users?

• How many predefined OTBI analyses have been run in the past month?

• How many analyses and dashboards failed in the past month?

• What is the database SQL execution time and row count?

• How many ad-hoc OTBI analyses have been run in the past month?

• How many OTBI SOAP web services have been run in the past month?

• Which subject areas have large data volume?

• Which data security policy would provide access to the data I need to see?

• Can I view and edit a particular page? If yes, which functional security policy do I need to provide to a user who needs similar access?

• Which roles were added with a specific functional security policy, and who added them?

• How many users run OTBI analyses?

• What are the top N most frequently-run OTBI analyses?

• Why am I not able to view certain subject areas with my login credentials?

• I have not added a specific role to a user, but the user seem to have this job role. Can I trace how has this been inherited by the user?

• What are all the data security privileges that a specific user added?

• What is the weekly OTBI analysis usage trend?

• How many custom OTBI analyses have been run in the past month?

• What is the execution history of dashboard X in the past month?

• Which analyses have low usage in the past month?

• What are the long-running analyses in the past month?

• Which analyses have high data row count?

• What is the OTBI execution time histogram in the past month?

• Which analyses reached OTBI max row limit?

• What are the common execution errors in the past month?

• What are the most commonly used OTBI subject areas?

• Which analyses have the longest response time?

• Which subject areas have slow performance?

• What are the least-used OTBI subject areas?

• Which analyses have low usage because of poor performance?