Repository navigation
DB Permission requirements #15716
Unanswered
tspearconquest
asked this question in
Q&A
DB Permission requirements
#15716
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
Hi,
We are working to migrate a Keycloak database for our dev environment from one server to another. DB type is Postgres in both servers. Postgres version 11 in the old server, and Postgres 14 in the new server.
In the new server, we are using Terraform to manage privileges of the keycloak role to the database and considered that Keycloak may or may not use
TEMPORARYprivilege on the DB. We would like to grant only theCONNECTprivilege at the db for the role, and avoid grantingTEMPORARYprivilege.I tried to search the code but found only many references to the temporary password option, and nothing related to creating/deleting temporary tables.
Can anyone confirm if Keycloak uses
TEMPORARYprivilege?Additionally, we would like to identify if keycloak needs the
CREATEprivilege to create new schemas in the database.Thanks in advance
All reactions