I'm using pg 7.3 on freebsd..
I've created a database use sql.
now, as the pg superuser I cant seem to grant any permissions on the
tables in the db..
npcenter-# \z
Access privileges for database npcenter
Schema |Table | Access privileges
+--+---
On Thu, 4 Nov 2004, David Bear wrote:
I'm using pg 7.3 on freebsd..
I've created a database use sql.
now, as the pg superuser I cant seem to grant any permissions on the
tables in the db..
npcenter-# \z
Access privileges for database npcenter
Schema |Table | Access privileges
On Thu, Nov 04, 2004 at 05:07:20PM -0700, David Bear wrote:
npcenter=# grant all on table 'contactNames' to group npcenter;
ERROR: syntax error at or near 'contactNames' at character 20
Try double quotes:
grant all on table contactNames to group npcenter;