no :-)
just add
"sameuser" under
DATABASE
in your configuration line in pg_hba.conf
or read this:
# This record identifies networked hosts that are
permitted to connect
# via IP connections.
#
# Format:
#
# host DBNAME IP_ADDRESS ADDRESS_MASK AUTH_TYPE
[AUTH_ARGUMENT]
#
# DBNAME can be:
# o the name of a PostgreSQL database
# o "all" to indicate all databases
# o "sameuser" to allow access only to databases with
the same
# name as the connecting user
so replace "all" with "sameuser" where you need this.
# TYPE DATABASE IP_ADDRESS MASK
AUTH_TYPE AUTH_ARGUMENT
local all
trust
host all 127.0.0.1 255.255.255.255
trust
--- Thomas Beutin <tyrone@laokoon.IN-Berlin.DE> wrote:
> Hi,
>
> On Mon, Jul 15, 2002 at 08:44:39AM +0200, Fabrizio
> wrote:
> > i made a page in php interfacing with postgresql
> server. i had a problem but
> > i solve that one assuming postmaster with options
> -i and specifying port
> > 5432. but then, when i call via browser my page,
> it returns error "fatal1:
> > user apache does not exist...". if i must modify
> pg_hba.conf, how can i do?
> > thanx
> Look for the "createuser" shell command. And don't
> forget to give the permission
> for the tables to this user ("GRANT" command on the
> psql prompt).
> OR
> Connect to the databes as the database super (NOT
> RECOMMENDED).
>
> INHO the best thing is to create an user apache
> without permission for
> database or table creation.
>
> -tb
> --
> Thomas Beutin
> tb@laokoon.IN-Berlin.DE
> Beam me up, Scotty. There is no intelligent live
> down in Redmond.
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
__________________________________________________
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.com