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:

• 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?

• Can I view and edit the manage employment screen, if yes, which functional security policy do I need to provide to the user?

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

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

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

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

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

• How many users run OTBI analyses?

• I have not added the Compensation analyst role to user, however the user seem to have this job role, can I trace how has this been inherited by the user?

• I haven't 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?

• List all the Data Security Privileges that were added by a specific user

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

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

• What are the least-used OTBI subject areas?

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

• What are the most commonly used OTBI subject areas?

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

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

• What is the current predicate vs prior predicate values of the data security policy?

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

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

• What is the total number of updates that have happened on a data security policy?

• What is the weekly OTBI analysis usage trend?

• What is total number of changes done on a functional security policy during the day?

• Which analyses have high data row count?

• Which analyses have low usage because of poor performance?

• Which analyses have low usage in the past month?

• Which analyses have the longest response time?

• Which analyses reached OTBI max row limit?

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

• Which data security policy would provide access to the talent profile data ?

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

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

• Which subject areas have large data volume?

• Which subject areas have slow performance?

• Which user has added/removed the specific functional security policy?

• Who are the top N OTBI users?

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

• Why am I not able to view succession management subject areas with my login?