sso-postgres
v1.1.0
Published
* SSO-Postgres provisions user accounts for a Postgres database using your central identity provider(s).
Downloads
2
Readme
sso-postgres
SSO-Postgres provisions user accounts for a Postgres database using your central identity provider(s).
SSO-Postgres does not require an enterprise license for any database
SSO-Postgres utilizes JIT user creation when a user requests access.
SSO-Postgres supports multiple database types, consolidating them under a single identity provider.
SSO Example
Supported Databases
- Postgres
- Aurora Postgres
- MySQL
- Mongodb
Supported Identity Providers
- AzureAD
- Google Oauth
- Auth0
- Any strategy supported by PassportJS
Configuration
SSO-Postgres uses environment variables for configuration (set with an .env file at the server's root directory).
Environment variables:
- PG_DEFAULT_PERMISSIONS="all privileges"
- G_OAUTH_API_KEY=""
- G_OAUTH_SECRET=""
- AUTH_METHOD=<your selected identity provider e.g. google, azuread, facebook>
- HOST_NAME=localhost
- SESSION_SECRET=
- API_HOSTNAME=localhost
- UI_HOSTNAME=localhost
- API_PORT=3001
- UI_PORT=3001 // can host UI in a CDN technically