1 Reply Latest reply on Jun 15, 2018 9:28 AM by Scott Dickinson

    Postgres data for Content Permissions and Project Hierarchy

    Scott Dickinson

      I am trying to build out a dashboard so we can tell a few things from Postgres


      1 - Project hierarchy - How to tell if a project is a subfolder, and which project it is under, and if its 1,2,3,etc.. levels down.


      2 - How to tell if the permissions are locked at the project level or unlocked.


      Can someone tell me which tables these are in, and which tables(s) I may need to join?

      We want to incorporate this with out permissions level by security group/project/workbook views.