| From: | Kashif Zeeshan <kashi(dot)zeeshan(at)gmail(dot)com> |
|---|---|
| To: | somnath som <som(dot)somnath16(at)gmail(dot)com> |
| Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: User Privileges Issue |
| Date: | 2024-08-30 11:43:36 |
| Message-ID: | CAAPsdheM_hGwXqZxfUh8Bid5f_MAAr6dqU6SL1qEGunfx4ihhg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi Somnath
Use the system catalog tables to get the information you need, for a
reference please check the below link.
https://stackoverflow.com/questions/40759177/postgresql-show-all-the-privileges-for-a-concrete-user
Thanks
Kashif Zeehsan
On Fri, Aug 30, 2024 at 4:38 PM somnath som <som(dot)somnath16(at)gmail(dot)com> 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.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Muhammad Usman Khan | 2024-08-30 11:44:57 | Re: User Privileges Issue |
| Previous Message | Domen Šetar | 2024-08-30 08:12:56 | Postgresql backup problem |