Fw: Problems whit role and privileges

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



http-equiv=3DContent-Type>

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