Generates SQL to revoke all privileges held by a role in the current database.
pgext.cloud · Source code · Documentation · License text · Control file
| Package | drop_role_helper |
|---|---|
| Version | 1.0 |
| Repository | Unspecified |
| Extension type | SQL only |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | Yes |
| Stars | 7 |
| Latest commit | 2023-06-05 |
| Catalogue updated | 2026-08-30 |
| plpgsql | PL/pgSQL procedural language |
| tencentdb_superuser | TencentDB administration extension that supplies the managed pg_tencentdb_superuser role and privileges. |
| custom_roles | Role-specific Supabase RLS tables and functions for managing user roles. |
| grants_manager | Declarative PL/pgSQL toolkit for snapshotting, reporting, and aligning database object grants. |
| pg_role_fkey_trigger_functions | A bunch of trigger functions to help establish and/or maintain referential integrity for columns that reference PostgreSQL ROLE NAMEs. |
| rds_hwdrs_privs | Huawei Cloud RDS helper extension for granting selected replication and catalog privileges. |
| set_user | similar to SET ROLE but with added logging |
| monitoring_role | Security-definer monitoring wrappers for a non-privileged role |
| pointsource@supabase_rbac | Role-Based Access Control for your Supabase project |