| From: | Jens Tröger <jens(dot)troeger(at)light-speed(dot)de> |
|---|---|
| To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
| Cc: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: LOCK docs and permissions |
| Date: | 2024-04-05 12:12:37 |
| Message-ID: | Zg_qtRzgiKJVN3sJ@light-speed.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
Thank you, Laurenz, I missed that completely 🤦🏻♂️
Jens
> https://www.postgresql.org/docs/current/sql-lock.html#id-1.9.3.155.7
>
> "To lock a table, the user must have the right privilege for the specified
> lockmode, or be the table's owner or a superuser. If the user has UPDATE,
> DELETE, or TRUNCATE privileges on the table, any lockmode is permitted.
> If the user has INSERT privileges on the table, ROW EXCLUSIVE MODE
> (or a less-conflicting mode as described in Section 13.3) is permitted.
> If a user has SELECT privileges on the table, ACCESS SHARE MODE is permitted."
>
> Yours,
> Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Doc comments form | 2024-04-05 20:26:09 | RE: ts_headline performance note |
| Previous Message | Laurenz Albe | 2024-04-05 12:09:53 | Re: LOCK docs and permissions |