Hey Sean! Thank you for such a quick and useful response. I figured these keys were hiding somewhere in the source-code, but wasn't anxious to go digging.
This is perfect! And thanks also for the extra info. -John On Wednesday, July 27, 2022 at 2:43:04 PM UTC-4 [email protected] wrote: > 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: *[email protected] <[email protected]> on behalf > of John Fitzgerald <[email protected]> > *Date: *Wednesday, July 27, 2022 at 1:28 PM > *To: *DSpace Technical Support <[email protected]> > *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 [email protected]. > 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/b8a38c91-5a8b-4a2a-a063-8bbdc74c11c5n%40googlegroups.com.
