Kevin Field <kevinjamesfield@xxxxxxxxx> writes: > Strange, no? Anybody have any ideas why this might be? Worksforme: regression=# create group "user"; CREATE ROLE regression=# create group extranet_user in group "user"; CREATE ROLE regression=# create user x in group extranet_user; CREATE ROLE regression=# create view page_startup as select ... CREATE VIEW regression=# GRANT SELECT ON TABLE page_startup TO "user"; GRANT regression=# set session authorization x; SET regression=> select * from page_startup; [ works ] I'm a bit suspicious of naming a group "user". I wonder whether you outsmarted yourself somewhere along the line by failing to double-quote that name, so that the command ended up doing something else than you thought. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
