Automic Workload Automation

Expand all | Collapse all

How to create a restricted view on uc4 database to specific app?

  • 1.  How to create a restricted view on uc4 database to specific app?

    Posted 11-04-2015 03:15 PM

    can I create a restricted view on uc4 database to one of my clients that would allow my client to only viewing records for their application ?

     

     

    One of the applications teams that running jobs on uc4 in  my environment requested read access to our uc4\prod database to  allow them to view the process of their jobs from the database side

     

    business agreed to approve the request only if our DB can create a view that would restrict their team to only viewing records with MIB-specific information

     

    since our db is not familiar with uc4 database structure , like where the job reports are stored, they are not able to determine if they can process this request

     

    could you please assist us to figure all that out in order to set that up?

     

     



  • 2.  How to create a restricted view on uc4 database to specific app?

    Posted 11-12-2015 05:27 PM
    Is Automic/UC4 using an Oracle repository or MS SS? 

    Automic does NOT recommend reading the DB directly because the the DB schema can change.

    I can help some if you are on Oracle - on your own if using MSSS.


  • 3.  How to create a restricted view on uc4 database to specific app?

    Posted 11-17-2015 10:27 AM
    to view the process of their jobs from the database side
    => What do they want to see?

    As Pat mentioned, basically we do not recommend using selects to our DB due to several reasons.