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?


Norma R

----- Original Message ----- 
From: "Bastien Koert" <[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]>
> >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
> >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.
>   Start enjoying all the benefits of MSNŽ Premium right now and get the
> first two months FREE*.

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to