Tables Permission

Поиск
Список
Период
Сортировка
Искать

Tables Permission

От:
Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>
Дата:
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?

	I am looking forward to heard from all you.
	Thanks a lot!

Re: Tables Permission

От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:
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
FAQ