| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Elielson Fontanezi <ElielsonF(at)prodam(dot)sp(dot)gov(dot)br> |
| Cc: | "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>, Gerson Leite da Silva <gerson(dot)silva(at)prodam(dot)sp(dot)gov(dot)br>, Marcio Pacheco de Jesus <mjesus(at)prodam(dot)sp(dot)gov(dot)br> |
| Subject: | Re: Tables Permission |
| Date: | 2002-07-16 16:47:32 |
| Message-ID: | 200207161647.g6GGlWu04294@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeremy Buchmann | 2002-07-16 17:09:11 | Re: Problem compiling PostgreSQL 7.2.1 on RedHat 7.2 |
| Previous Message | Elielson Fontanezi | 2002-07-16 16:44:44 | Tables Permission |