PostgreSQL
Connect TigerIdentity to PostgreSQL for dynamic credential generation, just-in-time access, and comprehensive query auditing.
Key Features
Dynamic Credentials
Generate short-lived PostgreSQL users with specific privileges on-demand.
Role Management
Sync and manage PostgreSQL roles, grants, and database permissions.
Query Auditing
Track all queries executed by temporary users with complete audit trails.
Row-Level Security
Integrate with PostgreSQL RLS policies for fine-grained data access control.
Auto-Revocation
Automatically revoke database credentials when sessions expire or policies change.
Just-In-Time Access
Request database access only when needed with automatic cleanup.
How It Works
Configure Admin Access
Provide TigerIdentity with admin credentials to manage PostgreSQL users and roles.
Sync Schema
TigerIdentity syncs existing roles, grants, and database configurations.
Request Access
Users request database access through TigerIdentity with specific privileges.
Generate Credentials
Temporary PostgreSQL users are created with scoped permissions and automatic expiration.
Configuration Example
connector:
type: postgresql
name: "postgres-production"
config:
host: "postgres.company.com"
port: 5432
admin_user: "${POSTGRES_ADMIN_USER}"
admin_password: "${POSTGRES_ADMIN_PASSWORD}"
databases:
- production_db
- analytics_db
sync:
roles: true
grants: true
users: true
provisioning:
enabled: true
user_prefix: "tiger_"
default_ttl: 3600
max_ttl: 28800
revocation_statements:
- "REVOKE ALL ON ALL TABLES IN SCHEMA public FROM {{name}}"
- "DROP USER {{name}}"Use Cases
Zero Standing Database Access
Eliminate permanent database credentials. Grant access only when needed with automatic revocation.
Developer Self-Service
Allow developers to request temporary read or write access to specific databases.
Production Data Access
Enforce strict controls on production database access with approval workflows and MFA.
Compliance Auditing
Track every database query to sensitive tables with user attribution and context.
Ready to connect PostgreSQL?
See how TigerIdentity transforms database access security in a personalized demo.
Schedule Your Demo