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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
