Re: Database Grants Bug

Marcus England wrote:
> Grants do not work at the database level using the syntax mentioned in
> the documentation. i.e.:
>
> GRANT ALL ON DATABASE dbname TO GROUP groupname;
>
> Or
>
> GRANT ALL ON DATABASE dbname TO username;
>

Works here:

regression=# select version();
version
-----------------------------------------------------------------
PostgreSQL 7.3.3 on i686-redhat-linux-gnu, compiled by GCC 2.96
(1 row)

regression=# GRANT ALL ON DATABASE regression TO GROUP grp1;
GRANT
regression=# GRANT ALL ON DATABASE regression TO user1;
GRANT

You need to be more specific in what you mean by "do not work". Do you
get an error? What exactly is not working?

Perhaps you expect more than you should -- re-read the docs,
specifically the section quoted here:

GRANT { { CREATE | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] }
ON DATABASE dbname [, ...]
TO { username | GROUP groupname | PUBLIC } [, ...]

In the context of DATABASE, ALL means "CREATE & TEMPORARY & TEMP",
nothing more, nothing less. Further reading provides:

CREATE
For databases, allows new schemas to be created within the database.

TEMPORARY
TEMP
Allows temporary tables to be created while using the database.

Are these not working?

HTH,

Joe