Re: Able to do ALTER DEFAULT PRIVILEGES from a user who is not the owner

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: rajan <vgmonnet(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Able to do ALTER DEFAULT PRIVILEGES from a user who is not the owner
Date: 2019-02-02 13:53:42
Message-ID: 87bm3u8fki.fsf@news-spur.riddles.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>>>>> "rajan" == rajan <vgmonnet(at)gmail(dot)com> writes:

rajan> --with the student user have no privilege how ALTER DEFAULT PRIVILEGES
rajan> works????
rajan> *learning=> ALTER DEFAULT PRIVILEGES IN SCHEMA additional GRANT INSERT ON
rajan> TABLES TO student;

This ALTER only affects the default privileges for tables created by
the role "student" (because they're the ones executing the ALTER), it
does not affect default privileges for tables created by anybody else.

--
Andrew (irc:RhodiumToad)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2019-02-02 14:48:16 Re: fast defaults in heap_getattr vs heap_deform_tuple
Previous Message Amit Langote 2019-02-02 13:52:37 Re: speeding up planning with partitions