Re: User Privileges Issue - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: User Privileges Issue
Date
Msg-id ff9b10af53aa19f7cb7939b43d1b01c53a4ee730.camel@cybertec.at
Whole thread Raw
In response to User Privileges Issue  (somnath som <som.somnath16@gmail.com>)
List pgsql-admin
On Thu, 2024-08-29 at 17:22 +0530, somnath som wrote:
> We have one user like “Test_User”, Can I check what all previliges are there for “Test_User”.
> When running \du+ command then only can see for superuser, others user are not showing.
> Please provide me command to check what all previliges are there for a user.

There is nothing like that built into PostgreSQL.

Perhaps the pg_permissions extension can help:
https://github.com/cybertec-postgresql/pg_permissions

Yours,
Laurenz Albe



pgsql-admin by date:

Previous
From: Rajesh Kumar
Date:
Subject: DR set up.
Next
From: Laurenz Albe
Date:
Subject: Re: Postgresql Database and PG_WAL locations