Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Security Role allowing Mgmt to stop scheduled reports others have developed

32
Views
2
Comments

Summary

Security Role allowing Mgmt to stop scheduled reports others have developed

Content

My reporting team has the following concern and would appreciate any advice.  Currently running R13 and using BIP and OTBI.

Concern:  A Developer from another team builds and schedules a report to run daily.  The developer leaves the company.  It seems, at this time, none of the HR team can kill that scheduled query because we don't have the security role to view or disable it.

Is there a security role that my team should have that will allow us to do what is needed above; monitor and if needed stop queries that others have scheduled?  Or is there an alternative to accomplish this?  Our security team tried adding the "ESS Administrator Role", but had an issue with it not being valid when added to our profile.

Thank you

Tagged:

Comments

  • VijayaBaskar Ranganathan
    VijayaBaskar Ranganathan Rank 1 - Community Starter

    One other approach is to create a common user (like interface or service account ) and schedule all the jobs using this common user instead of individual users. 

  • Rich R
    Rich R Rank 3 - Community Apprentice

    Thanks, Vijaya.  I assume in order to enforce this, we would need to remove some permissions from any users whose role currently allowed them to schedule.  Do you have any info on this?