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 option. For example below, alice is missing the grant option and she gets that warning when she wants to grant her privileges to bob. =# CREATE ROLE alice; CREATE ROLE bob; CREATE TABLE t (a int); CREATE ROLE CREATE ROLE CREATE TABLE =# GRANT ALL ON t TO alice; GRANT =# SET ROLE alice; SET => GRANT ALL ON t TO bob; WARNING: no privileges were granted for "t" GRANT With GRANT ALL ON t TO alice WITH GRANT OPTION it would've worked. -- Erik
