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:[EMAIL PROTECTED]] Enviada em: ter�a-feira, 16 de julho de 2002 13:48 Para: Elielson Fontanezi Cc: '[EMAIL PROTECTED]'; 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 [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
