RES: Tables Permission - Mailing list pgsql-admin

From Elielson Fontanezi
Subject RES: Tables Permission
Date
Msg-id A799F7647794D311924A005004ACEA97080DDE21@cprodamibs249.prodam
Whole thread Raw
List pgsql-admin
Ok!
But I´m trying to workaround this...
Do you know any way to prevent objects creation by any user? and
allow just read authorities int 7.2.1 version?

-----Mensagem original-----
De: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
Enviada em: terça-feira, 16 de julho de 2002 13:48
Para: Elielson Fontanezi
Cc: 'pgsql-admin@postgresql.org'; Gerson Leite da Silva; Marcio Pacheco
de Jesus
Assunto: Re: [ADMIN] Tables Permission


Elielson Fontanezi wrote:
> Hi folks!
>
>     I've been learning postgres 7.2 two weeks so far, and I could find
> that
> no dba?s users can create new objects in a different database that it do
not
> own or,
> at least, do not have authorities to create new objects.
>
>     For example, assume two databases: postgresdb database owned only by
> dba user "postgres" and leodb where exists only the no dba user "leo" with
> INSERT, DELETE and UPDATE authorities. So, why? Why leo can create a new
> objects in postgresdb?

Preventing table creation is a missing feature that will exist in 7.3
with schemas.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-admin by date:

Previous
From: Jeremy Buchmann
Date:
Subject: Re: Problem compiling PostgreSQL 7.2.1 on RedHat 7.2
Next
From: Peter Eisentraut
Date:
Subject: Re: Problem compiling PostgreSQL 7.2.1 on RedHat 7.2