Re: Grants and privileges issue

2024-03-28 Thread Erik Wienhold
On 2024-03-28 22:43 +0100, sud wrote: > Regarding my second question, I am still unable to find out why we are > seeing "*no privileges were granted for cron/partman/part_config*' message > while adding the grants to the user? Because the role that is granting the privileges is missing the grant o

Re: Grants and privileges issue

2024-03-28 Thread sud
On Fri, Mar 29, 2024 at 2:43 AM Adrian Klaver wrote: > > > On 3/28/24 2:10 PM, sud wrote: > > Hi, It's postgres 15.4. > > > > We want to give required privilege to certain users or roles and ensure > > to not to provide any elevated privilege. I have below questions, > > I would suggest spending

Re: Grants and privileges issue

2024-03-28 Thread Adrian Klaver
On 3/28/24 2:10 PM, sud wrote: Hi, It's postgres 15.4. We want to give required privilege to certain users or roles and ensure to not to provide any elevated privilege. I have below questions, I would suggest spending some time here: https://www.postgresql.org/docs/current/ddl-priv.html