Esta é uma mensagem em várias partes no formato MIME.
------=_NextPart_000_0051_01CAFB58.A74792E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi Tom,
I agree with you about the default permissions for the public schema.
I do not understand is why the Dependencies tab (in pgAdmin III) of =
public schema displays all the roles (admweb, usuweb, admsfar, ususfar)
Example:
Dependencies tab
Type Name Restriction
Role admweb ACL
Role usuweb ACL
Role admsfar ACL
Role ususfar ACL
I did this setting. Am I interpreting the dependencies tab in the wrong =
way?
Thanks
Eduardo.
From: "Tom Lane" <tgl [at] sss.pgh.pa.us>
Sent: Friday, May 21, 2010 6:21 PM
To: "Eduardo S=E1 dos Reis" <eduardoreis [at] pjf.mg.gov.br>
Subject: Re: [ADMIN] Problems whit role and privileges
That looks exactly as I'd expect --- it's the default permissions for
the public schema. What were you expecting?
regards, tom lane
From: Eduardo S=E1 dos Reis
Sent: Friday, May 21, 2010 5:51 PM
To: Tom Lane
Subject: Re: [ADMIN] Problems whit role and privileges
Hi Tom,
I analyzed the following:
1 - I have the following roles: admweb, usuweb, admsfar, ususfar
2 - I have the following databases: db_web, db_sfar
3 - I had to create a new database db_fin
4 - Then I accessed the public schema of this database (db_fin) with =
pgAdmin III.
I noticed that the Dependencies tab displays all the roles (admweb, =
usuweb, admsfar, ususfar)
Example:
Aba Dependencieis (database db_fin)
Type Name Restriction
Role admweb ACL
Role usuweb ACL
Role admsfar ACL
Role ususfar ACL
But when access privileges of the public schema (with pgAdmin III), the =
following appears:
User/Group Privileges
postgres UC
public UC
Can you help me ?
Thanks.
Eduardo
--------------------------------------------------
From: "Tom Lane" <tgl [at] sss.pgh.pa.us>
Sent: Friday, May 21, 2010 4:08 PM
To: "Eduardo S=E1 dos Reis" <eduardoreis [at] pjf.mg.gov.br>
Cc: <pgsql-admin [at] postgresql.org>
Subject: Re: [ADMIN] Problems whit role and privileges
> =3D?iso-8859-1?Q?Eduardo_S=3DE1_dos_Reis?=3D =
<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
------=_NextPart_000_0051_01CAFB58.A74792E0
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>Hi Tom,</FONT></DIV>
<DIV><FONT face=3DCalibri></FONT> </DIV>
<DIV><FONT face=3DCalibri><SPAN id=3Dresult_box class=3Dlong_text><SPAN
style=3D"BACKGROUND-COLOR: #fff" title=3D"" closure_uid_s3ylgd=3D"99"
lc=3D"Eu concordo com voc=EA sobre as permiss=F5es default do esquema =
public."
mc=3D"I agree with you about the permissions of the default public =
schema.
">I
agree with you about the <FONT face=3D"Times New Roman">default =
permissions for
the public schema</FONT>.</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=3DCalibri><SPAN class=3Dlong_text><SPAN
style=3D"BACKGROUND-COLOR: #fff" title=3D"" closure_uid_s3ylgd=3D"99"
lc=3D"Eu concordo com voc=EA sobre as permiss=F5es default do esquema =
public."
mc=3D"I agree with you about the permissions of the default public =
schema.
"><SPAN
id=3Dresult_box class=3Dlong_text><SPAN title=3D"" =
closure_uid_s3ylgd=3D"393"
lc=3D"o que eu n=E3o entendi =E9 porque ao acessar the public schema of =
this database with pgAdmin III the Dependencies tab displays all the =
roles (admweb, usuweb, admsfar, ususfar)"
mc=3D"I do not understand is why the public access to the schema of this =
database with pgAdmin III the Dependencies tab displays all the roles =
(admweb, usuweb, admsfar, ususfar)
"><SPAN
id=3Dresult_box class=3Dlong_text><SPAN style=3D"BACKGROUND-COLOR: #fff" =
title=3D""
closure_uid_s3ylgd=3D"553"
lc=3D"o que eu n=E3o entendi =E9 porque the Dependencies tab (in PGADMIN =
III) of public schema displays all the roles (admweb, usuweb, admsfar, =
ususfar)"
mc=3D"I do not understand is why the Dependencies tab (in pgAdmin III) =
of public schema displays all the roles (admweb, usuweb, admsfar, =
ususfar)
">I
do not understand is why the Dependencies tab (in pgAdmin III) of public =
schema
displays all the roles (admweb, usuweb, admsfar,
ususfar)</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></FONT></DIV>
<DIV><FONT face=3DCalibri><SPAN class=3Dlong_text><SPAN
style=3D"BACKGROUND-COLOR: #fff" title=3D"" closure_uid_s3ylgd=3D"99"
lc=3D"Eu concordo com voc=EA sobre as permiss=F5es default do esquema =
public."
mc=3D"I agree with you about the permissions of the default public =
schema.
"><SPAN
class=3Dlong_text><SPAN title=3D"" closure_uid_s3ylgd=3D"393"
lc=3D"o que eu n=E3o entendi =E9 porque ao acessar the public schema of =
this database with pgAdmin III the Dependencies tab displays all the =
roles (admweb, usuweb, admsfar, ususfar)"
mc=3D"I do not understand is why the public access to the schema of this =
database with pgAdmin III the Dependencies tab displays all the roles =
(admweb, usuweb, admsfar, ususfar)
"><SPAN
class=3Dlong_text><SPAN style=3D"BACKGROUND-COLOR: #fff" title=3D""
closure_uid_s3ylgd=3D"553"
lc=3D"o que eu n=E3o entendi =E9 porque the Dependencies tab (in PGADMIN =
III) of public schema displays all the roles (admweb, usuweb, admsfar, =
ususfar)"
mc=3D"I do not understand is why the Dependencies tab (in pgAdmin III) =
of public schema displays all the roles (admweb, usuweb, admsfar, =
ususfar)
"><BR></SPAN><SPAN
style=3D"BACKGROUND-COLOR: #fff" title=3D"" closure_uid_s3ylgd=3D"554"
lc=3D"Aba Dependencieis (database db_fin)"
mc=3D"Dependencies tab (database =
db_fin)
">Example:</SPAN></SPAN></SPAN></SPAN></SPAN><=
/SPAN></FONT></DIV>
<DIV><FONT face=3DCalibri><SPAN class=3Dlong_text><SPAN
style=3D"BACKGROUND-COLOR: #fff" title=3D"" closure_uid_s3ylgd=3D"99"
lc=3D"Eu concordo com voc=EA sobre as permiss=F5es default do esquema =
public."
mc=3D"I agree with you about the permissions of the default public =
schema.
"><SPAN
class=3Dlong_text><SPAN title=3D"" closure_uid_s3ylgd=3D"393"
lc=3D"o que eu n=E3o entendi =E9 porque ao acessar the public schema of =
this database with pgAdmin III the Dependencies tab displays all the =
roles (admweb, usuweb, admsfar, ususfar)"
mc=3D"I do not understand is why the public access to the schema of this =
database with pgAdmin III the Dependencies tab displays all the roles =
(admweb, usuweb, admsfar, ususfar)
"><SPAN
class=3Dlong_text><SPAN style=3D"BACKGROUND-COLOR: #fff" title=3D""
closure_uid_s3ylgd=3D"554" lc=3D"Aba Dependencieis (database db_fin)"
mc=3D"Dependencies tab (database =
db_fin)
"></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></=
FONT> </DIV>
<DIV><FONT face=3DCalibri><SPAN class=3Dlong_text><SPAN
style=3D"BACKGROUND-COLOR: #fff" title=3D"" closure_uid_s3ylgd=3D"99"
lc=3D"Eu concordo com voc=EA sobre as permiss=F5es default do esquema =
public."
mc=3D"I agree with you about the permissions of the default public =
schema.
"><SPAN
class=3Dlong_text><SPAN title=3D"" closure_uid_s3ylgd=3D"393"
lc=3D"o que eu n=E3o entendi =E9 porque ao acessar the public schema of =
this database with pgAdmin III the Dependencies tab displays all the =
roles (admweb, usuweb, admsfar, ususfar)"
mc=3D"I do not understand is why the public access to the schema of this =
database with pgAdmin III the Dependencies tab displays all the roles =
(admweb, usuweb, admsfar, ususfar)
"><SPAN
class=3Dlong_text><SPAN style=3D"BACKGROUND-COLOR: #fff" title=3D""
closure_uid_s3ylgd=3D"554" lc=3D"Aba Dependencieis (database db_fin)"
mc=3D"Dependencies tab (database =
db_fin)
">Dependencies tab
</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></FONT></DIV>
<DIV><FONT face=3DCalibri><SPAN class=3Dlong_text><SPAN
style=3D"BACKGROUND-COLOR: #fff" title=3D"" closure_uid_s3ylgd=3D"99"
lc=3D"Eu concordo com voc=EA sobre as permiss=F5es default do esquema =
public."
mc=3D"I agree with you about the permissions of the default public =
schema.
"><SPAN
class=3Dlong_text><SPAN title=3D"" closure_uid_s3ylgd=3D"393"
lc=3D"o que eu n=E3o entendi =E9 porque ao acessar the public schema of =
this database with pgAdmin III the Dependencies tab displays all the =
roles (admweb, usuweb, admsfar, ususfar)"
mc=3D"I do not understand is why the public access to the schema of this =
database with pgAdmin III the Dependencies tab displays all the roles =
(admweb, usuweb, admsfar, ususfar)
"><SPAN
class=3Dlong_text><SPAN style=3D"BACKGROUND-COLOR: #fff" title=3D""
closure_uid_s3ylgd=3D"554" lc=3D"Aba Dependencieis (database db_fin)"
mc=3D"Dependencies tab (database =
db_fin)
"><BR></SPAN><SPAN
style=3D"BACKGROUND-COLOR: #fff" title=3D"" closure_uid_s3ylgd=3D"555"
lc=3D"Type Name Restriction" mc=3D"Type Name Restriction
">Type =
Name
Restriction<BR></SPAN><SPAN style=3D"BACKGROUND-COLOR: #fff" title=3D""
closure_uid_s3ylgd=3D"556" lc=3D"Role admweb ACL"
mc=3D"Role admweb ACL
">Role admweb ACL<BR></SPAN><SPAN =
title=3D""
closure_uid_s3ylgd=3D"557" lc=3D"Role usuweb ACL"
mc=3D"Role usuweb ACL
">Role usuweb ACL<BR
style=3D"BACKGROUND-COLOR: #fff"></SPAN><SPAN title=3D"" =
closure_uid_s3ylgd=3D"558"
lc=3D"Role admsfar ACL" mc=3D"Role admsfar ACL
">Role admsfar
ACL<BR></SPAN><SPAN title=3D"" closure_uid_s3ylgd=3D"559" lc=3D"Role =
ususfar ACL"
mc=3D"Role ususfar ACL">Role ususfar
ACL</SPAN></SPAN></SPAN></SPAN><BR></DIV></SPAN></SPAN></FONT>
<DIV><FONT face=3DCalibri></FONT> </DIV>
<DIV><FONT face=3DCalibri><SPAN id=3Dresult_box class=3Dshort_text><SPAN =
style=3D"BACKGROUND-COLOR: #fff" title=3D"" closure_uid_s3ylgd=3D"872"
lc=3D"eu n=E3o fiz esta defini=E7=E3o." mc=3D"I did this setting. ">I =
did this setting.
</SPAN><SPAN style=3D"BACKGROUND-COLOR: #fff" title=3D"" =
closure_uid_s3ylgd=3D"893"
lc=3D"ser=E1 que estou interpretando a aba dependencies de maneira =
errada?"
mc=3D"Am I interpreting the dependencies tab in the wrong way?">Am I =
interpreting
the dependencies tab in the wrong way?</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=3DCalibri></FONT> </DIV>
<DIV><FONT face=3DCalibri>Thanks</FONT></DIV>
<DIV><FONT face=3DCalibri>Eduardo.</FONT></DIV>
<DIV><FONT face=3DCalibri></FONT> </DIV>
<DIV><FONT face=3DCalibri>From: "Tom Lane" <<A
title=3D"mailto:tgl [at] sss.pgh.pa.us
CTRL + Clique para seguir o link"
href=3D"mailto:tgl [at] sss.pgh.pa.us">tgl [at] sss.pgh.pa.us</A>><BR>Sent: =
Friday, May
21, 2010 6:21 PM<BR>To: "Eduardo S=E1 dos Reis" <<A
title=3D"mailto:eduardoreis [at] pjf.mg.gov.br
CTRL + Clique para seguir =
o link"
href=3D"mailto:eduardoreis [at] pjf.mg.gov.br">eduardoreis [at] pjf.mg .gov.br</A>&g=
t;<BR>Subject:
Re: [ADMIN] Problems whit role and privileges </FONT></DIV>
<DIV><FONT face=3DCalibri></FONT> </DIV>
<DIV>That looks exactly as I'd expect --- it's the default permissions
for<BR>the public schema. What were you expecting?<BR><BR>regards, =
tom
lane<BR></DIV>
<DIV style=3D"FONT: 10pt Tahoma">
<DIV style=3D"BACKGROUND: #f5f5f5">
<DIV style=3D"font-color: black"><B>From:</B> <A
title=3D"mailto:eduardoreis [at] pjf.mg.gov.br
CTRL + Clique para seguir =
o link"
href=3D"mailto:eduardoreis [at] pjf.mg.gov.br">Eduardo S=E1 dos Reis</A> =
</DIV>
<DIV><B>Sent:</B> Friday, May 21, 2010 5:51 PM</DIV>
<DIV><B>To:</B> <A
title=3D"mailto:tgl [at] sss.pgh.pa.us
CTRL + Clique para seguir o link"
href=3D"mailto:tgl [at] sss.pgh.pa.us">Tom Lane</A> </DIV>
<DIV><B>Subject:</B> Re: [ADMIN] Problems whit role and privileges
</DIV></DIV></DIV>
<DIV><BR></DIV>
<DIV><SPAN id=3Dresult_box class=3Dlong_text><SPAN title=3D""
lc=3D"Eu analisei o seguinte:" mc=3D"I analyzed the =
following:
"
closure_uid_l1bhys=3D"949"><FONT size=3D2 face=3DArial>Hi
Tom,</FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=3Dlong_text><SPAN title=3D"" lc=3D"Eu analisei o =
seguinte:"
mc=3D"I analyzed the following:
"
closure_uid_l1bhys=3D"949"><FONT size=3D2
face=3DArial></FONT></SPAN></SPAN> </DIV>
<DIV><SPAN class=3Dlong_text><SPAN title=3D"" lc=3D"Eu analisei o =
seguinte:"
mc=3D"I analyzed the following:
"
closure_uid_l1bhys=3D"949"><FONT size=3D2 face=3DArial>I analyzed the
following:<BR><BR></FONT></SPAN><SPAN title=3D""
lc=3D"1 - Possuo as seguintes roles: admweb, usuweb, admsfar, ususfar"
mc=3D"1 - I have the following roles: admweb, usuweb, admsfar, =
ususfar
"
closure_uid_l1bhys=3D"950"><FONT size=3D2 face=3DArial>1 - I have the =
following roles:
admweb, usuweb, admsfar, ususfar<BR><BR></FONT></SPAN><SPAN
style=3D"BACKGROUND-COLOR: #fff" title=3D""
lc=3D"2 - Tenho os seguintes bancos de dados: db_web, db_sfar"
mc=3D"2 - I have the following databases: db_web, =
db_sfar
"
closure_uid_l1bhys=3D"951"><FONT size=3D2 face=3DArial>2 - I have the =
following
databases: db_web, db_sfar<BR><BR></FONT></SPAN><FONT face=3DArial><FONT =
size=3D2><SPAN style=3D"BACKGROUND-COLOR: #fff" title=3D""
lc=3D"3 - Precisei criar um novo banco de dados db_fin"
mc=3D"3 - I had to create a new database db_fin
"
closure_uid_l1bhys=3D"952">3 - I had to create a new database
db_fin<BR><BR></SPAN><SPAN style=3D"BACKGROUND-COLOR: #fff" title=3D""
lc=3D"4 - Em seguida eu acessei o esquema public deste banco de dados =
com o pgadmin iii."
mc=3D"4 - Then I accessed the public schema of this database with =
pgAdmin III. "
closure_uid_l1bhys=3D"953">4 - Then I accessed the public schema of this =
database
(db_fin) with pgAdmin III. </SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=3Dlong_text><FONT face=3DArial><FONT size=3D2><SPAN
style=3D"BACKGROUND-COLOR: #fff" title=3D""
lc=3D"4 - Em seguida eu acessei o esquema public deste banco de dados =
com o pgadmin iii."
mc=3D"4 - Then I accessed the public schema of this database with =
pgAdmin III. "
closure_uid_l1bhys=3D"953"></SPAN><SPAN style=3D"BACKGROUND-COLOR: #fff" =
title=3D""
lc=3D"eu verifiquei que na aba Dependencies =E9 exibido todas as roles ( =
admweb, usuweb, admsfar, ususfar)"
mc=3D"I noticed that the Dependencies tab displays all the roles =
(admweb, usuweb, admsfar, ususfar)"
closure_uid_l1bhys=3D"954">I noticed that the Dependencies tab displays =
all the
roles (admweb, usuweb, admsfar, =
ususfar)</SPAN></FONT></FONT></SPAN><BR><FONT
size=3D2 face=3DArial>Example:<BR><BR>Aba Dependencieis (database
db_fin)<BR><BR>Type =
Name
Restriction<BR>Role admweb
ACL<BR>Role usuweb
ACL<BR>Role admsfar
ACL<BR>Role ususfar
ACL<BR></FONT> <BR><SPAN id=3Dresult_box class=3Dmedium_text><SPAN
style=3D"BACKGROUND-COLOR: #fff" title=3D""
lc=3D"mas quando acesso os privil=E9gios do esquema public (with PGAdmin =
III), o seguinte =E9 exibido:"
mc=3D"but when access privileges of the public schema (with pgAdmin =
III), the following appears:
"
closure_uid_l1bhys=3D"1079">But when access privileges of the public =
schema (with
pgAdmin III), the following appears:<BR><BR></SPAN><SPAN
style=3D"BACKGROUND-COLOR: #fff" title=3D"" lc=3D"User/Group Privileges" =
mc=3D"User / Group Privileges
"
closure_uid_l1bhys=3D"1080">User/Group =
;
Privileges<BR></SPAN><SPAN style=3D"BACKGROUND-COLOR: #fff" title=3D""
lc=3D"postgres UC" mc=3D"postgres UC
"
closure_uid_l1bhys=3D"1081">postgres &=
nbsp;
UC<BR></SPAN><SPAN style=3D"BACKGROUND-COLOR: #fff" title=3D"" =
lc=3D"public UC"
mc=3D"UC public"
closure_uid_l1bhys=3D"1086">public &nb=
sp; &nbs=
p; UC
</SPAN></SPAN><BR></DIV>
<DIV><FONT face=3DCalibri><SPAN style=3D"BACKGROUND-COLOR: #fff" =
title=3D""
lc=3D"voc=EA pode me ajudar" mc=3D"can you help me" =
closure_uid_l1bhys=3D"1126">Can you
help me ?</SPAN></FONT></DIV>
<DIV><FONT face=3DCalibri><SPAN style=3D"BACKGROUND-COLOR: #fff" =
title=3D""
lc=3D"voc=EA pode me ajudar" mc=3D"can you help me"
closure_uid_l1bhys=3D"1126"></SPAN></FONT> </DIV>
<DIV><FONT face=3DCalibri>Thanks.</FONT></DIV>
<DIV>Eduardo =
<BR><BR>--------------------------------------------------<BR>From:
"Tom Lane" <tgl [at] sss.pgh.pa.us><BR>Sent: Friday, May 21, 2010 4:08
PM<BR>To: "Eduardo S=E1 dos Reis" =
<eduardoreis [at] pjf.mg.gov.br><BR>Cc:
<pgsql-admin [at] postgresql.org><BR>Subject: Re: [ADMIN] Problems whit =
role
and privileges <BR><BR>> =3D?iso-8859-1?Q?Eduardo_S=3DE1_dos_Reis?=3D =
<eduardoreis [at] pjf.mg.gov.br> writes:<BR>>> I'm using =
postgresql 8.4
and have created several roles.<BR>>> When I create a new database =
and
then check the dependencies of schema public my previously created roles =
appear
as dependencies.<BR>>> I did not understand why. Can anyone help
me?<BR>> <BR>> I think most likely you're misinterpreting the =
dependency
data.<BR>> Would you show us exactly how you arrived at the above
conclusion?<BR>> <BR>> regards, tom lane<BR>> <BR>> -- =
<BR>> Sent
via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)<BR>> To =
make
changes to your subscription:<BR>>
http://www.postgresql.org/mailpref/pgsql-admin</DIV></BODY></HTML>
------=_NextPart_000_0051_01CAFB58.A74792E0--
