Hi John, Some more info here:
https://wiki.lyrasis.org/display/DSDOC6x/Functional+Overview#FunctionalOverview-Authorization Here’s a SQL case snippet you may find useful from one of my scripts: case when action_id=0 then 'READ' when action_id=1 then 'WRITE' when action_id=2 then 'DELETE' when action_id=3 then 'ADD' when action_id=4 then 'REMOVE' when action_id=5 then 'WORKFLOW_STEP_1' when action_id=6 then 'WORKFLOW_STEP_2' when action_id=7 then 'WORKFLOW_STEP_3' when action_id=8 then 'WORKFLOW_ABORT' when action_id=9 then 'DEFAULT_BITSTREAM_READ' when action_id=10 then 'DEFAULT_ITEM_READ' when action_id=11 then 'ADMIN' when action_id=12 then 'WITHDRAWN_READ' else 'UNKNOWN' end Action constants are defined in this source file: https://github.com/DSpace/DSpace/blob/dspace-6_x/dspace-api/src/main/java/org/dspace/core/Constants.java -- Sean From: dspace-tech@googlegroups.com <dspace-tech@googlegroups.com> on behalf of John Fitzgerald <iphi...@gmail.com> Date: Wednesday, July 27, 2022 at 1:28 PM To: DSpace Technical Support <dspace-tech@googlegroups.com> Subject: [dspace-tech] DS6 Database Question - "resourcepolicy" table Caution: This message was sent from outside the University of Manitoba. Howdy, Would someone please clue me in on what the "action_id" field in the "resourcepolicy" table is plugged into? I see no descriptive reference to it in any other tables. I'm trying to write some SQL-scripts to audit permissions on a large repository. Thanks, -John -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com<mailto:dspace-tech+unsubscr...@googlegroups.com>. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/5ba40dcc-e3a4-4218-809d-d88f2c1ff3a8n%40googlegroups.com<https://groups.google.com/d/msgid/dspace-tech/5ba40dcc-e3a4-4218-809d-d88f2c1ff3a8n%40googlegroups.com?utm_medium=email&utm_source=footer>. -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/YT3PR01MB8164E5C80E08B08807036D61E8979%40YT3PR01MB8164.CANPRD01.PROD.OUTLOOK.COM.
