Re: Trying to GRANT privileges on a newly-created database

On 05/02/2010 03:59 PM, Lou Picciano wrote:
>
>
> *[TEST REPORT]*
>
> *[Release]:* 8.5alpha2
>
> *[Test Type]:* psql CLI
>
> *[Test]:* Trying to GRANT privileges on a newly-created database
>
> *[Platform]:* Solaris SPARC 4u (E450)
>
> *[Parameters]:* Trying to GRANT privileges on a newly-created database.
> db name in lower case.
>
> *[Failure]: yes*
>
> *[Results]:*
>
> # CREATE DATABASE dbname;
>
> # GRANT ALL ON dbname TO role;
>
> ERROR: relatioypn "dbname" does not exist
>
> Please note this database is created in lower case; it has not been
> renamed from upper.
>
> # GRANT ALL ON dbname TO role; - produces the same error.

In general, to do a grant on anything other that a table you need to
name the object type, i.e.

GRANT ALL ON DATABASE dbname TO role;

That's been true for quite a while.

--
                                   -- Josh Berkus
                                      PostgreSQL Experts Inc.
                                      http://www.pgexperts.com