restrict user rights - Mailing list pgsql-general

From Alain Roger
Subject restrict user rights
Date
Msg-id 75645bbb0606270645t55caa808uca0cc193cdff8242@mail.gmail.com
Whole thread Raw
List pgsql-general
Hi,

I have some little issue with restricting right for a profile.

i've created a profile "kmt_admin" that should have only access to "kmt" database.
this profile should be able to create table, functions, .... but it should not have access to other databases or to create additional profiles...
i setup everything according documentation and whe i try to connect with PHPpgadmin, the profile kmt_admin can have access to all database as a super user...

please, could you help me ?

thanks a lot,

Alain

pgsql-general by date:

Previous
From: dananrg@yahoo.com
Date:
Subject: Re: Best open source tool for database design / ERDs?
Next
From: Martijn van Oosterhout
Date:
Subject: Re: psql -h host ...