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