Thread: Trying to GRANT privileges on a newly-created database
[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: relation "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.
[Comments]: We've seen that users have this problem with mixed-case object names, and must use quotes. Our example names have always been in lowercase - have not bee rename, and we've tried commands both without tnd with quotes! Have we somehow corrupted this cluster? Am seeing other strange behavior related to simple commands.
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