restrict user rights

From: "Alain Roger" <raf(dot)news(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: restrict user rights
Date: 2006-06-27 13:45:16
Message-ID: 75645bbb0606270645t55caa808uca0cc193cdff8242@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-06-27 13:50:01 Re: psql -h host ...
Previous Message Franz.Rasper 2006-06-27 13:05:17 Re: RAID + PostgreSQL?