Am Freitag, 23. Dezember 2005 22:06 schrieb robert mena:
> GRANT CREATE,REFERENCES ON DATABASE test TO testadm;
>
> \z
> Access privileges for database "test"
> Schema | Name | Type | Access privileges
> --------+------+------+-------------------
>
> How can I specify that the user testadm can perform those actions to this
> database?
For one thing, the command \z shows table privileges, so the empty table above
is not surprising. pg_database would give you better information.
Second, the privilege type REFERENCES does not exist for databases, only for
tables, so the command you executed does not make sense.
I suggest you peruse the GRANT manual page again.
