Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to automate catalog object names into a table with object level permissions?

User_834AGOct 19 2023 — edited Oct 19 2023

Hello all,

We have a requirement to bring the catalog objects data( Shared folders/sub folders & reports) into a table with permissions and on daily basis It needs to be automated.

Example: in the shared folder we have A,B folders,

A has C,D sub folders,

B has E sub folder and each sub folder or folder has set of reports.

So In the table, We need all the folder names, sub folder names & set of report names in a Database table and it has to refresh daily (means any new folder /report created, in the next run time It must appear in the table by using any technology).

All the ideas are appreciated.

Thanks,

Pradeep.

Comments
Post Details
Added on Oct 19 2023
8 comments
527 views