Postgres Pro
Downloads
Home   >   mailing lists

Re: Able to do ALTER DEFAULT PRIVILEGES from a user who is not the owner - Mailing list pgsql-hackers

From Andrew Gierth
Subject Re: Able to do ALTER DEFAULT PRIVILEGES from a user who is not the owner
Date
Msg-id 87bm3u8fki.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Able to do ALTER DEFAULT PRIVILEGES from a user who is not theowner  (rajan <vgmonnet@gmail.com>)
Responses Re: Able to do ALTER DEFAULT PRIVILEGES from a user who is not theowner  (rajan <vgmonnet@gmail.com>)
List pgsql-hackers
Tree view 
>>>>> "rajan" == rajan  <vgmonnet@gmail.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)

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: speeding up planning with partitions
Next
From: Andres Freund
Date:
Subject: Re: fast defaults in heap_getattr vs heap_deform_tuple