This is a discussion on Re: Allow GRANT/REVOKE permissions to be applied to all schema objects with one command within the pgsql Hackers forums, part of the PostgreSQL category; --> "Merlin Moncure" <merlin.moncure@rcsonline.com> writes: >> You left out SEQUENCES. > And views, but he was just listing the acceptable ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| "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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org |