[ADMIN] pulling my hair out..

2004-11-04 Thread David Bear
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 +--+---

Re: [ADMIN] pulling my hair out..

2004-11-04 Thread Stephan Szabo
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

Re: [ADMIN] pulling my hair out..

2004-11-04 Thread Michael Fuhr
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;