Thread: GRANT role TO PUBLIC- not working?

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

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

This is just a guess, but notice that the error messages shows public in quotation marks.  Could
this be the problem?

Regards,

Richard Broersma Jr.

according the manual
(http://www.postgresql.org/docs/8.1/interactive/privileges.html), 'The
special name PUBLIC can be used to grant a privilege to every role on
the system.'

So, "PUBLIC" may be considered as special keyword when granting
_priveleges_, not roles.

On 8/1/06, Brian Hurt <bhurt@janestcapital.com> wrote:
>
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>


--
Best regards,
Nikolay