pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedProblems whit role and privileges
4+ messages / 2 participants
[nested] [flat]
* Problems whit role and privileges
@ 2010-05-21 18:37 Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>
2010-05-21 19:08 ` Re: Problems whit role and privileges Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Eduardo Sá dos Reis @ 2010-05-21 18:37 UTC (permalink / raw)
To: pgsql-admin
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
Thanks a lot.
Eduardo
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Problems whit role and privileges
2010-05-21 18:37 Problems whit role and privileges Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>
@ 2010-05-21 19:08 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2010-05-21 19:08 UTC (permalink / raw)
To: Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>; +Cc: pgsql-admin
=?iso-8859-1?Q?Eduardo_S=E1_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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Fw: Problems whit role and privileges
@ 2010-05-24 12:01 Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>
0 siblings, 0 replies; 4+ messages in thread
From: Eduardo Sá dos Reis @ 2010-05-24 12:01 UTC (permalink / raw)
To: 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
From: Eduardo Sá 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@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
> =?iso-8859-1?Q?Eduardo_S=E1_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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Fw: Problems whit role and privileges
@ 2010-05-24 18:49 Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>
0 siblings, 0 replies; 4+ messages in thread
From: Eduardo Sá dos Reis @ 2010-05-24 18:49 UTC (permalink / raw)
To: pgsql-admin; +Cc: Tom Lane <tgl@sss.pgh.pa.us>
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
From: Eduardo Sá 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@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
> =?iso-8859-1?Q?Eduardo_S=E1_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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2010-05-24 18:49 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-05-21 18:37 Problems whit role and privileges Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>
2010-05-21 19:08 ` Tom Lane <tgl@sss.pgh.pa.us>
2010-05-24 12:01 Fw: Problems whit role and privileges Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>
2010-05-24 18:49 Fw: Problems whit role and privileges Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox