GRANT role TO PUBLIC- not working?

From: Brian Hurt <bhurt(at)janestcapital(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: GRANT role TO PUBLIC- not working?
Date: 2006-08-01 19:06:49
Message-ID: 44CFA649.7080803@janestcapital.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


I'm having problems granting a role to PUBLIC. According to the manual,
you do this by:
GRANT role TO PUBLIC;

but when I try this, I get an error:

bhurt_dev=# GRANT test_role TO PUBLIC;
ERROR: role "public" does not exist
bhurt_dev=#

This is Postgresql 8.01.0004. Any ideas?

Brian

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Richard Broersma Jr 2006-08-01 19:20:07 Re: GRANT role TO PUBLIC- not working?
Previous Message Tom Lane 2006-07-31 20:56:04 Re: precompiling regular expressions in plpgsql