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

Change Postgres configuration to store JWT secret #281

Open
anagradova opened this issue Oct 17, 2022 · 1 comment
Open

Change Postgres configuration to store JWT secret #281

anagradova opened this issue Oct 17, 2022 · 1 comment
Assignees
Labels
needs refinement this issue requires further refinement task WS: Authentication & API

Comments

@anagradova
Copy link
Contributor

Description

This command must be run to set up the database to store the JWT secret so that it is not exposed in any database functions as per the Postgrest documentation (https://postgrest.org/en/stable/auth.html)

ALTER DATABASE mydb SET "app.jwt_secret" TO 'reallyreallyreallyreallyverysafe';

User Story

No response

Architectural Decision Records (ADRs)

No response

@anagradova
Copy link
Contributor Author

Used already in the database for the JWT_gen function. We will need to determine the maintenance process for the system in production.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
needs refinement this issue requires further refinement task WS: Authentication & API
Projects
None yet
Development

No branches or pull requests

2 participants