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.
Obviously I am blind and saw how to see if permissions are locked to the project or not from the projects table and "Controlled Permissions Enabled"