Received: from maia.hub.org (maia-4.hub.org [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 5C1B5659F1C for ; Mon, 24 May 2010 15:58:00 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 82186-05-3 for ; Mon, 24 May 2010 18:57:50 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from webshield01.pjf.mg.gov.br (187-072-160-221.static.ctbctelecom.com.br [187.72.160.221]) by mail.postgresql.org (Postfix) with SMTP id EDAA365ACB4 for ; Mon, 24 May 2010 15:48:59 -0300 (ADT) Received: from (unknown [192.168.254.5]) by webshield01.pjf.mg.gov.br with smtp id 2fe2_04f2_eef3827a_6764_11df_87cc_002219d6be93; Mon, 24 May 2010 15:48:25 -0300 Received: from localhost (localhost [127.0.0.1]) by internet01.pjf.mg.gov.br (Postfix) with ESMTP id 5A14D6BDC2; Mon, 24 May 2010 15:48:54 -0300 (BRT) X-Virus-Scanned: Debian amavisd-new at pjf.mg.gov.br Received: from internet01.pjf.mg.gov.br ([127.0.0.1]) by localhost (internet01.pjf.mg.gov.br [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id efHPCzjyV1r3; Mon, 24 May 2010 15:48:53 -0300 (BRT) Received: from P01140047 (unknown [10.0.12.49]) by internet01.pjf.mg.gov.br (Postfix) with SMTP id 52E156BDED; Mon, 24 May 2010 15:48:53 -0300 (BRT) Message-ID: <88B015B630EB41E8AB6BFB1A1292734C@P01140047> From: =?iso-8859-1?Q?Eduardo_S=E1_dos_Reis?= To: Cc: "Tom Lane" Subject: Fw: Problems whit role and privileges Date: Mon, 24 May 2010 15:49:11 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0051_01CAFB58.A74792E0" X-Priority: 3 X-MSMail-Priority: Normal Importance: Normal X-Mailer: Microsoft Windows Live Mail 14.0.8089.726 X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8089.726 X-NAI-Spam-Flag: NO X-NAI-Spam-Level: X-NAI-Spam-Threshold: 2 X-NAI-Spam-Score: 0.5 X-NAI-Spam-Rules: 2 Rules triggered FROM_NAME=0.5, RV3541=0 X-NAI-Spam-Version: 2.2.0.9149 : core <3541> : streams <480346> : uri <60510 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.802 tagged_above=-10 required=5 tests=BAYES_50=0.8, HTML_FONT_LOW_CONTRAST=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201005/224 X-Sequence-Number: 34697 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=20 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" Sent: Friday, May 21, 2010 6:21 PM To: "Eduardo S=E1 dos Reis" Subject: Re: [ADMIN] Problems whit role and privileges=20 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=20 Sent: Friday, May 21, 2010 5:51 PM To: Tom Lane=20 Subject: Re: [ADMIN] Problems whit role and privileges=20 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.=20 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 =20 But when access privileges of the public schema (with pgAdmin III), the = following appears: User/Group Privileges postgres UC public UC=20 Can you help me ? Thanks. Eduardo=20 -------------------------------------------------- From: "Tom Lane" Sent: Friday, May 21, 2010 4:08 PM To: "Eduardo S=E1 dos Reis" Cc: Subject: Re: [ADMIN] Problems whit role and privileges=20 > =3D?iso-8859-1?Q?Eduardo_S=3DE1_dos_Reis?=3D = 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? >=20 > I think most likely you're misinterpreting the dependency data. > Would you show us exactly how you arrived at the above conclusion? >=20 > regards, tom lane >=20 > --=20 > Sent via pgsql-admin mailing list (pgsql-admin@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
Hi Tom,
 
I=20 agree with you about the default = permissions for=20 the public schema.
I=20 do not understand is why the Dependencies tab (in pgAdmin III) of public = schema=20 displays all the roles (admweb, usuweb, admsfar,=20 ususfar)

Example:
<= /SPAN>
 
Dependencies tab=20

Type = Name=20 Restriction
Role admweb ACL
Role usuweb ACLRole admsfar=20 ACL
Role ususfar=20 ACL

 
I = did this setting.=20 Am I = interpreting=20 the dependencies tab in the wrong way?
 
Thanks
Eduardo.
 
From: "Tom Lane" <tgl@sss.pgh.pa.us>
Sent: = Friday, May=20 21, 2010 6:21 PM
To: "Eduardo S=E1 dos Reis" <eduardoreis@pjf.mg.gov.br&g= t;
Subject:=20 Re: [ADMIN] Problems whit role and privileges
 
That looks exactly as I'd expect --- it's the default permissions=20 for
the public schema.  What were you expecting?

regards, = tom=20 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=20

Hi=20 Tom,
 
I analyzed the=20 following:

1 - I have the = following roles:=20 admweb, usuweb, admsfar, ususfar

2 - I have the = following=20 databases: db_web, db_sfar

3 - I had to create a new database=20 db_fin

4 - Then I accessed the public schema of this = database=20 (db_fin) with pgAdmin III.
I noticed that the Dependencies tab displays = all the=20 roles (admweb, usuweb, admsfar, = ususfar)
Example:

Aba Dependencieis (database=20 db_fin)

Type     = Name     =20 Restriction
Role     admweb   =20 ACL
Role     usuweb    =20 ACL
Role     admsfar   =20 ACL
Role     ususfar    =20 ACL
 
But when access privileges of the public = schema (with=20 pgAdmin III), the following appears:

User/Group      = ;   =20 Privileges
postgres      &= nbsp;          =20 UC
public      &nb= sp;           &nbs= p;   UC=20
Can you=20 help me ?
 
Thanks.
Eduardo =

--------------------------------------------------
From:=20 "Tom Lane" <tgl@sss.pgh.pa.us>
Sent: Friday, May 21, 2010 4:08=20 PM
To: "Eduardo S=E1 dos Reis" = <eduardoreis@pjf.mg.gov.br>
Cc:=20 <pgsql-admin@postgresql.org>
Subject: Re: [ADMIN] Problems whit = role=20 and privileges

> =3D?iso-8859-1?Q?Eduardo_S=3DE1_dos_Reis?=3D = <eduardoreis@pjf.mg.gov.br> writes:
>> I'm using = postgresql 8.4=20 and have created several roles.
>> When I create a new database = and=20 then check the dependencies of schema public my previously created roles = appear=20 as dependencies.
>> I did not understand why. Can anyone help=20 me?
>
> I think most likely you're misinterpreting the = dependency=20 data.
> Would you show us exactly how you arrived at the above=20 conclusion?
>
> regards, tom lane
>
> -- =
> Sent=20 via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To = make=20 changes to your subscription:
>=20 http://www.postgresql.org/mailpref/pgsql-admin
------=_NextPart_000_0051_01CAFB58.A74792E0--