Thread: Problems whit role and privileges

Problems whit role and privileges

From
Eduardo Sá dos Reis
Date:
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

Re: Problems whit role and privileges

From
Tom Lane
Date:
=?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