similar to SET ROLE but with added logging
pgext.cloud · Source code · License text · Control file
| Package | set_user |
|---|---|
| Version | 4.2.0 |
| PostgreSQL versions | 14 · 15 · 16 · 17 · 18 |
| Repository | PGDG |
| Extension type | Preloaded |
| Requires CREATE EXTENSION | Yes |
| Requires preload | Yes |
| Trusted | No |
| Relocatable | No |
| Shared libraries | set_user |
| Stars | 78 |
| Latest commit | 2026-06-05 |
| Latest release | 2025-09-24 |
| Catalogue updated | 2026-08-30 |
| pg_permissions | view object permissions and compare them with the desired state |
| login_hook | login_hook - hook to execute login_hook.login() at login time |
| pg_auth_mon | monitor connection attempts per user |
| pg_session_jwt | Manage authentication sessions using JWTs |
| auth_delay | pause briefly before reporting authentication failure |
| pgaudit | provides auditing functionality |
| pg_roast | Opinionated PostgreSQL database auditor |
| pg_readonly | cluster database read only |
| acl | ACL Data type |
| pg_command_fw | DDL and utility command firewall for PostgreSQL |