Re: security rights per database DDL/DML connect - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: security rights per database DDL/DML connect
Date
Msg-id 20021023033758.GB2719@wolff.to
Whole thread Raw
In response to security rights per database DDL/DML connect  (Gabor Faludi <falu@fits.hu>)
Responses Re: security rights per database DDL/DML connect  (Dan Langille <dan@langille.org>)
List pgsql-admin
On Tue, Oct 22, 2002 at 21:01:59 +0200,
  Gabor Faludi <falu@fits.hu> wrote:
> I've been searching the web for a solution on this but no luck .
>
> I'm administering a webserver w/ PHP apps on . I had an idea to create an
> application database and give access to certain users to maintain the data
> within the database tables , but also I'd like to make sure only certain
> users are able to perform DDL commands. Or simply to revoke access for
> connecting to this db.

In 7.3 you can get a pretty good handle on this. The database owner can
restrict who can create schemas and schema owners can control who can
create objects in that schema.

pgsql-admin by date:

Previous
From: Jeff Boes
Date:
Subject: Re: Drop and reload table to clear corruption?
Next
From: Dan Langille
Date:
Subject: Re: security rights per database DDL/DML connect