Re: Grant Privileges on Postgres
| From: | Joshua D. Drake | Date: | Wed, 22 Sep 2004 15:16:35 +0000 |
| Subject: | Re: Grant Privileges on Postgres | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-36338@lists.php.net to get a copy of this message | ||
> =(...., 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@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*.
> >
>
>
--
Co-Founder
Command Prompt, Inc.
The wheel's spinning but the hamster's dead