Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add Visa - Permission Mapping to Ego DB #679

Open
Buwujiu opened this issue Mar 27, 2023 · 0 comments
Open

Add Visa - Permission Mapping to Ego DB #679

Buwujiu opened this issue Mar 27, 2023 · 0 comments
Assignees

Comments

@Buwujiu
Copy link
Contributor

Buwujiu commented Mar 27, 2023

Detailed Description

Add many to many relationship to Visa - Permissions.
A permission is a policy (ACL entity) and scope(mask) in ego. Example: SONG.READ.

Possible Implementation

Refer to the note in https://wiki.oicr.on.ca/display/OV/Investigation+-+Ga4gh+passports+in+Ego#InvestigationGa4ghpassportsinEgo-VisaTypes

Possible table structure:

CREATE TABLE ACLVISAPERMISSION (
  id                      UUID PRIMARY KEY,
  entity                  UUID,
  visaId                  UUID,
  mask                    ACLMASK NOT NULL,
  FOREIGN KEY (entity)    REFERENCES ACLENTITY(id),
  FOREIGN KEY (sid)       REFERENCES GA4GHVISA(id)
);
 
@Buwujiu Buwujiu added the new-feature Request is a new feature label Mar 27, 2023
@Buwujiu Buwujiu added ITCR-Passport and removed new-feature Request is a new feature labels Mar 27, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants