Re: Grants and privileges issue
От | Erik Wienhold |
---|---|
Тема | Re: Grants and privileges issue |
Дата | |
Msg-id | 3gtbyn5ax5u5ecyzw6iq6ep3jtuzuvhqyocdripu25pzt654vl@j25b5whguf63 обсуждение исходный текст |
Ответ на | Re: Grants and privileges issue (sud <suds1434@gmail.com>) |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: