| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Prathima Mulpuri <prathima(dot)mulpuri(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Account privileges |
| Date: | 2021-11-17 02:28:13 |
| Message-ID: | CAKFQuwYQ2+2+rw6M4CmtdFphBK0Q-e6TWnrtAHFj5HhgxEMPiA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tuesday, November 16, 2021, Prathima Mulpuri <prathima(dot)mulpuri(at)gmail(dot)com>
wrote:
>
> Please share any ideas and solutions for my requirement.
>
Drop the “function or a stored procedure” requirement, use an external
application language instead. Node.js for example.
Separate the listing of extra/missing privileges from the execution of code
to fix those things.
You didn’t mention how the software is supposed to know what is the correct
set of permissions. If you haven’t worked through that detail
conceptually, and with some manual query execution to prove out that it
works, that should be the first feature to design and implement.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-11-17 03:08:25 | Re: Row estimate on empty tables |
| Previous Message | Prathima Mulpuri | 2021-11-17 02:07:14 | Account privileges |