Fw: Problems whit role and privileges - Mailing list pgsql-admin

From Eduardo Sá dos Reis
Subject Fw: Problems whit role and privileges
Date
Msg-id BC7A0671502748C1AE71FA6C4D4B8A5B@P01140047
Whole thread Raw
List pgsql-admin
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@sss.pgh.pa.us>
Sent: Friday, May 21, 2010 6:21 PM
To: "Eduardo Sá dos Reis" <eduardoreis@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
Sent: Friday, May 21, 2010 5:51 PM
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@sss.pgh.pa.us>
Sent: Friday, May 21, 2010 4:08 PM
To: "Eduardo Sá dos Reis" <eduardoreis@pjf.mg.gov.br>
Cc: <pgsql-admin@postgresql.org>
Subject: Re: [ADMIN] Problems whit role and privileges

> Eduardo Sá dos Reis <eduardoreis@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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin

pgsql-admin by date:

Previous
From: Mikko Partio
Date:
Subject: Re: could not truncate directory "pg_subtrans": apparent wraparound
Next
From: "Josi Perez (3T Systems)"
Date:
Subject: Re: Trigger with dynamic SQL