Re: Grant Privileges on Postgres

Hi Bastien, I tried adding password parameter but it returns an error "sintax error at or near identified at character...". =(...., and yes Santoso I've read all the documentation about grant but it doesn't work. It's not possible to grant access to all tables of a database in postgres with a single instruction? Thank's Norma R ----- Original Message ----- From: "Bastien Koert" <bastien_k@hotmail.com> To: <norma.ramirez@tecnosoft.com.co> Sent: Tuesday, September 21, 2004 8:14 PM Subject: RE: [PHP-DB] Grant Privileges on Postgres > grant all privleges on test to newuser identified by 'password' > > to add a password parameter to it > > bastien > > > >From: "Norma Ramirez" <norma.ramirez@tecnosoft.com.co> > >To: <php-db@lists.php.net> > >Subject: [PHP-DB] Grant Privileges on Postgres > >Date: Tue, 21 Sep 2004 16:32:41 -0500 > > > >Hi all, I run this instruction on Postgres psql tool: > >grant all privileges on database test to newuser; > >The goal is to give all privileges to newuser(user that is not a superuser) > >on test, the owner is postgres but I need to give this other user > >privileges. > >The problem is, after run this instruction, the confirmation GRANT apears > >but when I try to manipulate the database test with newuser, the database > >server show error permisions. > > > >Some ideas? > > > >Thank's > > > > > >Norma > > > >-- > >PHP Database Mailing List (http://www.php.net/) > >To unsubscribe, visit: http://www.php.net/unsub.php > > > > _________________________________________________________________ > Designer Mail isn't just fun to send, it's fun to receive. Use special > stationery, fonts and colors. > http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines > Start enjoying all the benefits of MSN® Premium right now and get the > first two months FREE*. >