Problems whit role and privileges

Esta é uma mensagem em várias partes no formato MIME.

------=_NextPart_000_003B_01CAF8FB.8581DA80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

I'm using postgresql 8.4 and have created several roles.
When I create a new database and then check the dependencies of schema =
public my previously created roles appear as dependencies.
I did not understand why. Can anyone help me?

Example

Thanks a lot.

Eduardo
------=_NextPart_000_003B_01CAF8FB.8581DA80
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type>
<META name=3DGENERATOR content=3D"MSHTML 8.00.7600.16535"></HEAD>
<BODY style=3D"PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: =
15px"
id=3DMailContainerBody leftMargin=3D0 topMargin=3D0 =
CanvasTabStop=3D"true"
name=3D"Compose message area">
<DIV><FONT face=3DCalibri><SPAN id=3Dresult_box class=3Dlong_text><SPAN =
title=3D""
closure_uid_fc224r=3D"310"
lc=3D"eu estou utilizando o postgresql 8.4 e tenho v=E1rias roles =
criadas."
mc=3D"I'm using postgresql 8.4 and have created several =
roles. ">Hi,</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=3DCalibri><SPAN class=3Dlong_text><SPAN title=3D""
closure_uid_fc224r=3D"310"
lc=3D"eu estou utilizando o postgresql 8.4 e tenho v=E1rias roles =
criadas."
mc=3D"I'm using postgresql 8.4 and have created several =
roles. "></SPAN></SPAN></FONT> </DIV>
<DIV><FONT face=3DCalibri><SPAN class=3Dlong_text><SPAN title=3D""
closure_uid_fc224r=3D"310"
lc=3D"eu estou utilizando o postgresql 8.4 e tenho v=E1rias roles =
criadas."
mc=3D"I'm using postgresql 8.4 and have created several =
roles. ">I'm
using postgresql 8.4 and have created several roles.<BR></SPAN><SPAN
style=3D"BACKGROUND-COLOR: #fff" title=3D"" closure_uid_fc224r=3D"311"
lc=3D"Quando crio um novo banco de dados e em seguida verifico as =
depend=EAncias do esquema public minhas roles criadas anteriormente =
aparecem como dependencias."
mc=3D"When I create a new database and then check the dependencies of =
schema public my previously created roles appear as =
dependencies. ">When
I create a new database and then check the dependencies of schema public =
my
previously created roles appear as dependencies.<BR></SPAN><SPAN =
title=3D""
closure_uid_fc224r=3D"312" lc=3D"N=E3o entendi o porque."
mc=3D"I did not understand why. ">I did not understand why. </SPAN><SPAN =

style=3D"BACKGROUND-COLOR: #fff" title=3D"" closure_uid_fc224r=3D"313"
lc=3D"Algu=E9m pode me ajudar?" mc=3D"Can anyone help me?">Can anyone =
help
me?</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=3DCalibri></FONT> </DIV>
<DIV><FONT face=3DCalibri>Example </FONT></DIV>
<DIV><FONT face=3DCalibri></FONT> </DIV>
<DIV><FONT face=3DCalibri>Thanks a lot.</FONT></DIV>
<DIV><FONT face=3DCalibri></FONT> </DIV>
<DIV><FONT face=3DCalibri>Eduardo</FONT></DIV></BODY></HTML>

------=_NextPart_000_003B_01CAF8FB.8581DA80--
eduardoreis [ Fr, 21 Mai 2010 20:37 ] [ ID #2041846 ]

Re: Problems whit role and privileges

=?iso-8859-1?Q?Eduardo_S=E1_dos_Reis?= <eduardoreis [at] pjf.mg.gov.br> writes:
> I'm using postgresql 8.4 and have created several roles.
> When I create a new database and then check the dependencies of schema public my previously created roles appear as dependencies.
> I did not understand why. Can anyone help me?

I think most likely you're misinterpreting the dependency data.
Would you show us exactly how you arrived at the above conclusion?

regards, tom lane

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Tom Lane [ Fr, 21 Mai 2010 21:08 ] [ ID #2041847 ]
Datenbanken » gmane.comp.db.postgresql.admin » Problems whit role and privileges

Vorheriges Thema: Postgres for BLOB ?
Nächstes Thema: Asynchronous commit | Transaction loss at server crash