Re: Allow GRANT/REVOKE permissions to be applied to all schema objects with one command - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Allow GRANT/REVOKE permissions to be applied to all schema objects with one command
Date
Msg-id 26623.1106949468@sss.pgh.pa.us
Whole thread Raw
In response to Re: Allow GRANT/REVOKE permissions to be applied to all schema objects with one command  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
List pgsql-hackers
"Merlin Moncure" <merlin.moncure@rcsonline.com> writes:
>> You left out SEQUENCES.

> And views, but he was just listing the acceptable targets to the 'grant'
> command.  Basically, views and sequences are treated as tables in this
> respect.

Right.  Also, LANGUAGEs do not live within schemas, so they drop out of
the consideration as well.

Since FUNCTIONs grant EXECUTE to PUBLIC by default, I don't think we
need to worry too much about them either.  In practice it would be
enough to solve this problem for tables.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [pgsql-hackers] Group-count estimation statistics
Next
From: Andrew Dunstan
Date:
Subject: Re: -HEAD on FreeBSD 6-CURRENT build failures