> =(...., 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? No it is not. Why don't you actually paste the output of what you are trying to do. J > > Thank's > > Norma R > > ----- Original Message ----- > From: "Bastien Koert" <bastien_k@xxxxxxxxxxx> > To: <norma.ramirez@xxxxxxxxxxxxxxxx> > Sent: Tuesday, September 21, 2004 8:14 PM > Subject: RE: 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@xxxxxxxxxxxxxxxx> > > >To: <php-db@xxxxxxxxxxxxx> > > >Subject: 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*. > > > > -- Co-Founder Command Prompt, Inc. The wheel's spinning but the hamster's dead -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
