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" <t...@sss.pgh.pa.us> Sent: Friday, May 21, 2010 6:21 PM To: "Eduardo Sá dos Reis" <eduardor...@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" <t...@sss.pgh.pa.us> Sent: Friday, May 21, 2010 4:08 PM To: "Eduardo Sá dos Reis" <eduardor...@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?= <eduardor...@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
