|
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@xxxxxxxxxxxxx>
Sent: Friday, May 21, 2010 6:21 PM To: "Eduardo Sá dos Reis" <eduardoreis@xxxxxxxxxxxxx> Subject: Re: 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: 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@xxxxxxxxxxxxx> Sent: Friday, May 21, 2010 4:08 PM To: "Eduardo Sá dos Reis" <eduardoreis@xxxxxxxxxxxxx> Cc: <pgsql-admin@xxxxxxxxxxxxxx> Subject: Re: Problems whit role and privileges > =?iso-8859-1?Q?Eduardo_S=E1_dos_Reis?= <eduardoreis@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin |
