Re: [dspace-tech] DS6 Database Question - "resourcepolicy" table

2022-07-27 Thread John Fitzgerald
For my use, I ended up adding a table to the DB (posted here for future-reference), thanks again: *CREATE TABLE public."action" (action_id int4 NULL,verb varchar(50) NULL);INSERT INTO public."action" (action_id,verb) VALUES (0,'READ'), (1,'WRITE'), (2,'DELET

Re: [dspace-tech] DS6 Database Question - "resourcepolicy" table

2022-07-27 Thread John Fitzgerald
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 sean.k...@umanitoba.ca wrote:

Re: [dspace-tech] DS6 Database Question - "resourcepolicy" table

2022-07-27 Thread Sean Kalynuk
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