set_user

set_user

similar to SET ROLE but with added logging

Overview

IDExtensionPackageVersionCategoryLicenseLanguage
7160
set_user
set_user
4.1.0
SEC
PostgreSQL
C
AttributeHas BinaryHas LibraryNeed LoadHas DDLRelocatableTrusted
--s-d--
No
Yes
No
Yes
no
no
Relationships
See Also
pg_readonly
pg_permissions
pgaudit
login_hook
pgauditlogtofile
pg_auth_mon
credcheck
pgextwlist

Packages

TypeRepoVersionPG Major AvailabilityPackage PatternDependencies
EL
PGDG
4.1.0
18
17
16
15
14
13
set_user_$v*-
Debian
PGDG
4.1.0
18
17
16
15
14
13
postgresql-$v-set-user-
Linux / PGPG18PG17PG16PG15PG14PG13
el8.x86_64
PGDG 4.2.0
PGDG 4.1.0
PGDG 4.1.0
PGDG 4.1.0
PGDG 4.1.0
PGDG 4.1.0
el8.aarch64
PGDG 4.2.0
PGDG 4.1.0
PGDG 4.1.0
PGDG 4.1.0
PGDG 4.1.0
PGDG 4.1.0
el9.x86_64
PGDG 4.2.0
PGDG 4.1.0
PGDG 4.1.0
PGDG 4.1.0
PGDG 4.1.0
PGDG 4.1.0
el9.aarch64
PGDG 4.2.0
PGDG 4.1.0
PGDG 4.1.0
PGDG 4.1.0
PGDG 4.1.0
PGDG 4.1.0
el10.x86_64
PGDG 4.2.0
PGDG 4.1.0
PGDG 4.1.0
PGDG 4.1.0
PGDG 4.1.0
PGDG 4.1.0
el10.aarch64
PGDG 4.2.0
PGDG 4.1.0
PGDG 4.1.0
PGDG 4.1.0
PGDG 4.1.0
PGDG 4.1.0
d12.x86_64
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
d12.aarch64
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
d13.x86_64
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
d13.aarch64
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
u22.x86_64
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
u22.aarch64
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
u24.x86_64
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
u24.aarch64
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
PGDG 4.2.0
PackageVersionOSORGSIZEFile URL
set_user_184.2.0el8.x86_64pgdg26.8 KiBset_user_18-4.2.0-1PGDG.rhel8.x86_64.rpm
set_user_184.2.0el8.aarch64pgdg26.5 KiBset_user_18-4.2.0-1PGDG.rhel8.aarch64.rpm
set_user_184.2.0el9.x86_64pgdg26.5 KiBset_user_18-4.2.0-1PGDG.rhel9.x86_64.rpm
set_user_184.2.0el9.aarch64pgdg25.8 KiBset_user_18-4.2.0-1PGDG.rhel9.aarch64.rpm
set_user_184.2.0el10.x86_64pgdg27.0 KiBset_user_18-4.2.0-1PGDG.rhel10.x86_64.rpm
set_user_184.2.0el10.aarch64pgdg26.5 KiBset_user_18-4.2.0-1PGDG.rhel10.aarch64.rpm
postgresql-18-set-user4.2.0d12.x86_64pgdg35.1 KiBpostgresql-18-set-user_4.2.0-1.pgdg12+1_amd64.deb
postgresql-18-set-user4.2.0d12.aarch64pgdg34.7 KiBpostgresql-18-set-user_4.2.0-1.pgdg12+1_arm64.deb
postgresql-18-set-user4.2.0d13.x86_64pgdg35.1 KiBpostgresql-18-set-user_4.2.0-1.pgdg13+1_amd64.deb
postgresql-18-set-user4.2.0d13.aarch64pgdg34.8 KiBpostgresql-18-set-user_4.2.0-1.pgdg13+1_arm64.deb
postgresql-18-set-user4.2.0u22.x86_64pgdg35.1 KiBpostgresql-18-set-user_4.2.0-1.pgdg22.04+1_amd64.deb
postgresql-18-set-user4.2.0u22.aarch64pgdg34.7 KiBpostgresql-18-set-user_4.2.0-1.pgdg22.04+1_arm64.deb
postgresql-18-set-user4.2.0u24.x86_64pgdg34.6 KiBpostgresql-18-set-user_4.2.0-1.pgdg24.04+1_amd64.deb
postgresql-18-set-user4.2.0u24.aarch64pgdg34.1 KiBpostgresql-18-set-user_4.2.0-1.pgdg24.04+1_arm64.deb
PackageVersionOSORGSIZEFile URL
set_user_174.1.0el8.x86_64pgdg26.4 KiBset_user_17-4.1.0-1PGDG.rhel8.x86_64.rpm
set_user_174.1.0el8.aarch64pgdg26.1 KiBset_user_17-4.1.0-1PGDG.rhel8.aarch64.rpm
set_user_174.1.0el9.x86_64pgdg26.5 KiBset_user_17-4.1.0-1PGDG.rhel9.x86_64.rpm
set_user_174.1.0el9.aarch64pgdg25.8 KiBset_user_17-4.1.0-1PGDG.rhel9.aarch64.rpm
set_user_174.1.0el10.x86_64pgdg26.8 KiBset_user_17-4.1.0-2PGDG.rhel10.x86_64.rpm
set_user_174.1.0el10.aarch64pgdg26.4 KiBset_user_17-4.1.0-2PGDG.rhel10.aarch64.rpm
postgresql-17-set-user4.2.0d12.x86_64pgdg35.0 KiBpostgresql-17-set-user_4.2.0-1.pgdg12+1_amd64.deb
postgresql-17-set-user4.2.0d12.aarch64pgdg34.6 KiBpostgresql-17-set-user_4.2.0-1.pgdg12+1_arm64.deb
postgresql-17-set-user4.2.0d13.x86_64pgdg35.0 KiBpostgresql-17-set-user_4.2.0-1.pgdg13+1_amd64.deb
postgresql-17-set-user4.2.0d13.aarch64pgdg34.6 KiBpostgresql-17-set-user_4.2.0-1.pgdg13+1_arm64.deb
postgresql-17-set-user4.2.0u22.x86_64pgdg39.0 KiBpostgresql-17-set-user_4.2.0-1.pgdg22.04+1_amd64.deb
postgresql-17-set-user4.2.0u22.aarch64pgdg38.6 KiBpostgresql-17-set-user_4.2.0-1.pgdg22.04+1_arm64.deb
postgresql-17-set-user4.2.0u24.x86_64pgdg34.6 KiBpostgresql-17-set-user_4.2.0-1.pgdg24.04+1_amd64.deb
postgresql-17-set-user4.2.0u24.aarch64pgdg34.1 KiBpostgresql-17-set-user_4.2.0-1.pgdg24.04+1_arm64.deb
PackageVersionOSORGSIZEFile URL
set_user_164.1.0el8.x86_64pgdg26.4 KiBset_user_16-4.1.0-1PGDG.rhel8.x86_64.rpm
set_user_164.0.1el8.x86_64pgdg26.2 KiBset_user_16-4.0.1-2.rhel8.1.x86_64.rpm
set_user_164.1.0el8.aarch64pgdg26.2 KiBset_user_16-4.1.0-1PGDG.rhel8.aarch64.rpm
set_user_164.0.1el8.aarch64pgdg25.9 KiBset_user_16-4.0.1-2.rhel8.1.aarch64.rpm
set_user_164.1.0el9.x86_64pgdg26.5 KiBset_user_16-4.1.0-1PGDG.rhel9.x86_64.rpm
set_user_164.0.1el9.x86_64pgdg26.3 KiBset_user_16-4.0.1-2.rhel9.1.x86_64.rpm
set_user_164.1.0el9.aarch64pgdg25.9 KiBset_user_16-4.1.0-1PGDG.rhel9.aarch64.rpm
set_user_164.0.1el9.aarch64pgdg25.6 KiBset_user_16-4.0.1-2.rhel9.1.aarch64.rpm
set_user_164.1.0el10.x86_64pgdg26.8 KiBset_user_16-4.1.0-2PGDG.rhel10.x86_64.rpm
set_user_164.1.0el10.aarch64pgdg26.4 KiBset_user_16-4.1.0-2PGDG.rhel10.aarch64.rpm
postgresql-16-set-user4.2.0d12.x86_64pgdg35.0 KiBpostgresql-16-set-user_4.2.0-1.pgdg12+1_amd64.deb
postgresql-16-set-user4.2.0d12.aarch64pgdg34.6 KiBpostgresql-16-set-user_4.2.0-1.pgdg12+1_arm64.deb
postgresql-16-set-user4.2.0d13.x86_64pgdg35.0 KiBpostgresql-16-set-user_4.2.0-1.pgdg13+1_amd64.deb
postgresql-16-set-user4.2.0d13.aarch64pgdg34.6 KiBpostgresql-16-set-user_4.2.0-1.pgdg13+1_arm64.deb
postgresql-16-set-user4.2.0u22.x86_64pgdg38.5 KiBpostgresql-16-set-user_4.2.0-1.pgdg22.04+1_amd64.deb
postgresql-16-set-user4.2.0u22.aarch64pgdg38.1 KiBpostgresql-16-set-user_4.2.0-1.pgdg22.04+1_arm64.deb
postgresql-16-set-user4.2.0u24.x86_64pgdg34.5 KiBpostgresql-16-set-user_4.2.0-1.pgdg24.04+1_amd64.deb
postgresql-16-set-user4.2.0u24.aarch64pgdg34.0 KiBpostgresql-16-set-user_4.2.0-1.pgdg24.04+1_arm64.deb
PackageVersionOSORGSIZEFile URL
set_user_154.1.0el8.x86_64pgdg26.3 KiBset_user_15-4.1.0-1PGDG.rhel8.x86_64.rpm
set_user_154.0.1el8.x86_64pgdg26.0 KiBset_user_15-4.0.1-2.rhel8.x86_64.rpm
set_user_154.0.0el8.x86_64pgdg25.5 KiBset_user_15-4.0.0-1.rhel8.x86_64.rpm
set_user_154.1.0el8.aarch64pgdg26.1 KiBset_user_15-4.1.0-1PGDG.rhel8.aarch64.rpm
set_user_154.0.1el8.aarch64pgdg25.8 KiBset_user_15-4.0.1-2.rhel8.aarch64.rpm
set_user_154.0.0el8.aarch64pgdg25.2 KiBset_user_15-4.0.0-1.rhel8.aarch64.rpm
set_user_154.1.0el9.x86_64pgdg26.4 KiBset_user_15-4.1.0-1PGDG.rhel9.x86_64.rpm
set_user_154.0.1el9.x86_64pgdg26.1 KiBset_user_15-4.0.1-2.rhel9.x86_64.rpm
set_user_154.0.0el9.x86_64pgdg25.8 KiBset_user_15-4.0.0-1.rhel9.x86_64.rpm
set_user_154.1.0el9.aarch64pgdg25.8 KiBset_user_15-4.1.0-1PGDG.rhel9.aarch64.rpm
set_user_154.0.1el9.aarch64pgdg25.4 KiBset_user_15-4.0.1-2.rhel9.aarch64.rpm
set_user_154.0.0el9.aarch64pgdg25.1 KiBset_user_15-4.0.0-1.rhel9.aarch64.rpm
set_user_154.1.0el10.x86_64pgdg26.7 KiBset_user_15-4.1.0-2PGDG.rhel10.x86_64.rpm
set_user_154.1.0el10.aarch64pgdg26.3 KiBset_user_15-4.1.0-2PGDG.rhel10.aarch64.rpm
postgresql-15-set-user4.2.0d12.x86_64pgdg34.6 KiBpostgresql-15-set-user_4.2.0-1.pgdg12+1_amd64.deb
postgresql-15-set-user4.2.0d12.aarch64pgdg34.2 KiBpostgresql-15-set-user_4.2.0-1.pgdg12+1_arm64.deb
postgresql-15-set-user4.2.0d13.x86_64pgdg34.7 KiBpostgresql-15-set-user_4.2.0-1.pgdg13+1_amd64.deb
postgresql-15-set-user4.2.0d13.aarch64pgdg34.3 KiBpostgresql-15-set-user_4.2.0-1.pgdg13+1_arm64.deb
postgresql-15-set-user4.2.0u22.x86_64pgdg38.2 KiBpostgresql-15-set-user_4.2.0-1.pgdg22.04+1_amd64.deb
postgresql-15-set-user4.2.0u22.aarch64pgdg37.8 KiBpostgresql-15-set-user_4.2.0-1.pgdg22.04+1_arm64.deb
postgresql-15-set-user4.2.0u24.x86_64pgdg34.2 KiBpostgresql-15-set-user_4.2.0-1.pgdg24.04+1_amd64.deb
postgresql-15-set-user4.2.0u24.aarch64pgdg33.7 KiBpostgresql-15-set-user_4.2.0-1.pgdg24.04+1_arm64.deb
PackageVersionOSORGSIZEFile URL
set_user_144.1.0el8.x86_64pgdg26.3 KiBset_user_14-4.1.0-1PGDG.rhel8.x86_64.rpm
set_user_144.0.1el8.x86_64pgdg26.0 KiBset_user_14-4.0.1-2.rhel8.x86_64.rpm
set_user_144.0.0el8.x86_64pgdg25.5 KiBset_user_14-4.0.0-1.rhel8.x86_64.rpm
set_user_143.0.0el8.x86_64pgdg25.3 KiBset_user_14-3.0.0-1.rhel8.x86_64.rpm
set_user_144.1.0el8.aarch64pgdg26.1 KiBset_user_14-4.1.0-1PGDG.rhel8.aarch64.rpm
set_user_144.0.1el8.aarch64pgdg25.7 KiBset_user_14-4.0.1-2.rhel8.aarch64.rpm
set_user_144.0.0el8.aarch64pgdg25.2 KiBset_user_14-4.0.0-1.rhel8.aarch64.rpm
set_user_143.0.0el8.aarch64pgdg25.1 KiBset_user_14-3.0.0-1.rhel8.aarch64.rpm
set_user_144.1.0el9.x86_64pgdg26.4 KiBset_user_14-4.1.0-1PGDG.rhel9.x86_64.rpm
set_user_144.0.1el9.x86_64pgdg26.1 KiBset_user_14-4.0.1-2.rhel9.x86_64.rpm
set_user_144.0.0el9.x86_64pgdg25.8 KiBset_user_14-4.0.0-1.rhel9.x86_64.rpm
set_user_144.1.0el9.aarch64pgdg25.8 KiBset_user_14-4.1.0-1PGDG.rhel9.aarch64.rpm
set_user_144.0.1el9.aarch64pgdg25.4 KiBset_user_14-4.0.1-2.rhel9.aarch64.rpm
set_user_144.0.0el9.aarch64pgdg25.1 KiBset_user_14-4.0.0-1.rhel9.aarch64.rpm
set_user_143.0.0el9.aarch64pgdg25.0 KiBset_user_14-3.0.0-1.rhel9.aarch64.rpm
set_user_144.1.0el10.x86_64pgdg26.7 KiBset_user_14-4.1.0-2PGDG.rhel10.x86_64.rpm
set_user_144.1.0el10.aarch64pgdg26.3 KiBset_user_14-4.1.0-2PGDG.rhel10.aarch64.rpm
postgresql-14-set-user4.2.0d12.x86_64pgdg34.7 KiBpostgresql-14-set-user_4.2.0-1.pgdg12+1_amd64.deb
postgresql-14-set-user4.2.0d12.aarch64pgdg34.2 KiBpostgresql-14-set-user_4.2.0-1.pgdg12+1_arm64.deb
postgresql-14-set-user4.2.0d13.x86_64pgdg34.7 KiBpostgresql-14-set-user_4.2.0-1.pgdg13+1_amd64.deb
postgresql-14-set-user4.2.0d13.aarch64pgdg34.2 KiBpostgresql-14-set-user_4.2.0-1.pgdg13+1_arm64.deb
postgresql-14-set-user4.2.0u22.x86_64pgdg38.1 KiBpostgresql-14-set-user_4.2.0-1.pgdg22.04+1_amd64.deb
postgresql-14-set-user4.2.0u22.aarch64pgdg37.8 KiBpostgresql-14-set-user_4.2.0-1.pgdg22.04+1_arm64.deb
postgresql-14-set-user4.2.0u24.x86_64pgdg34.2 KiBpostgresql-14-set-user_4.2.0-1.pgdg24.04+1_amd64.deb
postgresql-14-set-user4.2.0u24.aarch64pgdg33.7 KiBpostgresql-14-set-user_4.2.0-1.pgdg24.04+1_arm64.deb
PackageVersionOSORGSIZEFile URL
set_user_134.1.0el8.x86_64pgdg26.2 KiBset_user_13-4.1.0-1PGDG.rhel8.x86_64.rpm
set_user_134.0.1el8.x86_64pgdg25.9 KiBset_user_13-4.0.1-2.rhel8.x86_64.rpm
set_user_134.0.0el8.x86_64pgdg25.3 KiBset_user_13-4.0.0-1.rhel8.x86_64.rpm
set_user_133.0.0el8.x86_64pgdg25.1 KiBset_user_13-3.0.0-1.rhel8.x86_64.rpm
set_user_132.0.1el8.x86_64pgdg22.5 KiBset_user_13-2.0.1-1.rhel8.x86_64.rpm
set_user_134.1.0el8.aarch64pgdg26.0 KiBset_user_13-4.1.0-1PGDG.rhel8.aarch64.rpm
set_user_134.0.1el8.aarch64pgdg25.7 KiBset_user_13-4.0.1-2.rhel8.aarch64.rpm
set_user_134.0.0el8.aarch64pgdg25.2 KiBset_user_13-4.0.0-1.rhel8.aarch64.rpm
set_user_133.0.0el8.aarch64pgdg25.1 KiBset_user_13-3.0.0-1.rhel8.aarch64.rpm
set_user_134.1.0el9.x86_64pgdg26.3 KiBset_user_13-4.1.0-1PGDG.rhel9.x86_64.rpm
set_user_134.0.1el9.x86_64pgdg26.0 KiBset_user_13-4.0.1-2.rhel9.x86_64.rpm
set_user_134.0.0el9.x86_64pgdg25.8 KiBset_user_13-4.0.0-1.rhel9.x86_64.rpm
set_user_134.1.0el9.aarch64pgdg25.8 KiBset_user_13-4.1.0-1PGDG.rhel9.aarch64.rpm
set_user_134.0.1el9.aarch64pgdg25.4 KiBset_user_13-4.0.1-2.rhel9.aarch64.rpm
set_user_134.0.0el9.aarch64pgdg25.1 KiBset_user_13-4.0.0-1.rhel9.aarch64.rpm
set_user_133.0.0el9.aarch64pgdg25.0 KiBset_user_13-3.0.0-1.rhel9.aarch64.rpm
set_user_134.1.0el10.x86_64pgdg26.7 KiBset_user_13-4.1.0-2PGDG.rhel10.x86_64.rpm
set_user_134.1.0el10.aarch64pgdg26.3 KiBset_user_13-4.1.0-2PGDG.rhel10.aarch64.rpm
postgresql-13-set-user4.2.0d12.x86_64pgdg34.4 KiBpostgresql-13-set-user_4.2.0-1.pgdg12+1_amd64.deb
postgresql-13-set-user4.2.0d12.aarch64pgdg34.3 KiBpostgresql-13-set-user_4.2.0-1.pgdg12+1_arm64.deb
postgresql-13-set-user4.2.0d13.x86_64pgdg34.5 KiBpostgresql-13-set-user_4.2.0-1.pgdg13+1_amd64.deb
postgresql-13-set-user4.2.0d13.aarch64pgdg34.4 KiBpostgresql-13-set-user_4.2.0-1.pgdg13+1_arm64.deb
postgresql-13-set-user4.2.0u22.x86_64pgdg37.2 KiBpostgresql-13-set-user_4.2.0-1.pgdg22.04+1_amd64.deb
postgresql-13-set-user4.2.0u22.aarch64pgdg36.5 KiBpostgresql-13-set-user_4.2.0-1.pgdg22.04+1_arm64.deb
postgresql-13-set-user4.2.0u24.x86_64pgdg34.1 KiBpostgresql-13-set-user_4.2.0-1.pgdg24.04+1_amd64.deb
postgresql-13-set-user4.2.0u24.aarch64pgdg33.7 KiBpostgresql-13-set-user_4.2.0-1.pgdg24.04+1_arm64.deb

Source

Install

To add the required PGDG / PIGSTY upstream repository, use:

pig repo add pgsql -u   # add PGDG + Pigsty repo and update cache (leave existing repos)

Install this extension with:

pig ext install set_user; # install by extension name, for the current active PG version
pig ext install set_user; # install via package alias, for the active PG version
pig ext install set_user -v 18;   # install for PG 18
pig ext install set_user -v 17;   # install for PG 17
pig ext install set_user -v 16;   # install for PG 16
pig ext install set_user -v 15;   # install for PG 15
pig ext install set_user -v 14;   # install for PG 14
pig ext install set_user -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION set_user;
Last updated on