> =(...., 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" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> 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" <[EMAIL PROTECTED]>
> > >To: <[EMAIL PROTECTED]>
> > >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*.
> >
> 
> 

-- 
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

Reply via email to