Re: help (maybe i'm a little stupid) - Mailing list pgsql-general

well, solving my problems, i noticed that:
- i had to create user apache with ono permissions granted at psql level (no
creation db, no create user)
- i had to reinstall php (4.2.17) and its php-pgsql interfaces
- after all operation i restarted services invoked above.
eh eh, reading so, it seems to me, i'm very stupid....
;-)
thanx again to all




----- Original Message -----
From: "Steve Brett" <SBrett@e-mis.com>
To: <terry@greatgulfhomes.com>; "'Thomas Beutin'"
<tyrone@laokoon.IN-Berlin.DE>; "'Fabrizio'" <fabrizio@eleveners.com>
Cc: <pgsql-general@postgresql.org>
Sent: Monday, July 15, 2002 4:58 PM
Subject: RE: [GENERAL] help (maybe i'm a little stupid)


> i've just tested this and it seems to be the case.
>
> i created a test db, then a test table, then a test user called fred.
>
> then i did a revoke all on fred and then granted select.
>
> then i connected as fred and tried to create a table and the table was
> created.
>
> i wouldn't have expected this to be the case ...
>
> Steve
>
> > -----Original Message-----
> > From: terry@greatgulfhomes.com [mailto:terry@greatgulfhomes.com]
> > Sent: 15 July 2002 15:42
> > To: 'Thomas Beutin'; 'Fabrizio'
> > Cc: pgsql-general@postgresql.org
> > Subject: Re: [GENERAL] help (maybe i'm a little stupid)
> >
> >
> > Yeah but, in 7.2.1 isn't it true that there is no way to stop
> > a user from
> > being able to create tables???  I tried myself, with no
> > success, and later
> > read on the newsgroup that it is a feature to be coming soon,
> > but current
> > release 7.2.1 does not have that control.
> >
> > Terry Fielder
> > Network Engineer
> > Great Gulf Homes / Ashton Woods Homes
> > terry@greatgulfhomes.com
> >
> > > -----Original Message-----
> > > From: pgsql-general-owner@postgresql.org
> > > [mailto:pgsql-general-owner@postgresql.org]On Behalf Of
> > Thomas Beutin
> > > Sent: Monday, July 15, 2002 9:17 AM
> > > To: Fabrizio
> > > Cc: pgsql-general@postgresql.org
> > > Subject: Re: [GENERAL] help (maybe i'm a little stupid)
> > >
> > >
> > > 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
> > >
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo@postgresql.org so that your
> > message can get through to the mailing list cleanly
> >
>