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.

Sign up for GitHub

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

Jump to bottom

List all organizations for a given user #9710

Open
mmmarcos opened this issue Feb 14, 2025 · 1 comment · May be fixed by #9807
Open

List all organizations for a given user #9710

mmmarcos opened this issue Feb 14, 2025 · 1 comment · May be fixed by #9807
Assignees
@AureliaDolo
Milestone
v3.4

Comments

@mmmarcos
Copy link
Contributor

mmmarcos commented Feb 14, 2025 •
edited by FirelightFlagboy
Loading

We want to list the organisation the user as access to in parsec-auth.

Fortunatly, The server as a human table where an email is associated to an organisation:

parsec-cloud/server/parsec/components/postgresql/migrations/datamodel.sql

Lines 73 to 80 in 7739f08

CREATE TABLE human (
_id SERIAL PRIMARY KEY,
organization INTEGER REFERENCES organization (_id) NOT NULL,
email VARCHAR(254) NOT NULL,
label VARCHAR(254) NOT NULL,
UNIQUE (organization, email)
);

@AureliaDolo AureliaDolo self-assigned this Feb 24, 2025
@AureliaDolo AureliaDolo linked a pull request Feb 24, 2025 that will close this issue
Draft
2 tasks
@mmmarcos mmmarcos added this to the v3.4 milestone Feb 24, 2025
@FirelightFlagboy
Copy link
Contributor

First add basic parsec-auth, then add QOL

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@AureliaDolo AureliaDolo

Labels
None yet
Projects
None yet
Milestone
v3.4
Development

Successfully merging a pull request may close this issue.

Add route to list organization per users. Scille/parsec-cloud
3 participants
@mmmarcos @FirelightFlagboy @AureliaDolo