On 18/08/2011 12:35 AM, John R Pierce wrote:
On 08/17/11 7:40 AM, Merlin Moncure wrote:
GRANT/REVOKE only constrain read/write privileges to a database.

at a table level, and even distinguishing between INSERT (writing new data) and UPDATING (updating existing data).

Column level, actually :-) and they can control read access as well as write access.

Further control for writes can be applied using triggers that RAISE EXCEPTION when they don't like something.

--
Craig Ringer

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to