Problems whit role and privileges

Problems whit role and privileges

am 21.05.2010 20:37:29 von eduardoreis

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=20

Thanks a lot.

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



http-equiv=3DContent-Type>

15px"=20
id=3DMailContainerBody leftMargin=3D0 topMargin=3D0 =
CanvasTabStop=3D"true"=20
name=3D"Compose message area">

title=3D""=20
closure_uid_fc224r=3D"310"=20
lc=3D"eu estou utilizando o postgresql 8.4 e tenho v=E1rias roles =
criadas."=20
mc=3D"I'm using postgresql 8.4 and have created several =
roles. ">Hi,

closure_uid_fc224r=3D"310"=20
lc=3D"eu estou utilizando o postgresql 8.4 e tenho v=E1rias roles =
criadas."=20
mc=3D"I'm using postgresql 8.4 and have created several =
roles. ">
 

closure_uid_fc224r=3D"310"=20
lc=3D"eu estou utilizando o postgresql 8.4 e tenho v=E1rias roles =
criadas."=20
mc=3D"I'm using postgresql 8.4 and have created several =
roles. ">I'm=20
using postgresql 8.4 and have created several roles.
style=3D"BACKGROUND-COLOR: #fff" title=3D"" closure_uid_fc224r=3D"311"=20
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."=20
mc=3D"When I create a new database and then check the dependencies of =
schema public my previously created roles appear as =
dependencies. ">When=20
I create a new database and then check the dependencies of schema public =
my=20
previously created roles appear as dependencies.
title=3D""=20
closure_uid_fc224r=3D"312" lc=3D"N=E3o entendi o porque."=20
mc=3D"I did not understand why. ">I did not understand why.

style=3D"BACKGROUND-COLOR: #fff" title=3D"" closure_uid_fc224r=3D"313"=20
lc=3D"Algu=E9m pode me ajudar?" mc=3D"Can anyone help me?">Can anyone =
help=20
me?

 

Example

 

Thanks a lot.

 

Eduardo


------=_NextPart_000_003B_01CAF8FB.8581DA80--

Re: Problems whit role and privileges

am 21.05.2010 21:08:07 von Tom Lane

=?iso-8859-1?Q?Eduardo_S=E1_dos_Reis?= 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin