Re: security rights per database DDL/DML connect

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Gabor Faludi <falu(at)fits(dot)hu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: security rights per database DDL/DML connect
Date: 2002-10-23 03:37:58
Message-ID: 20021023033758.GB2719@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Oct 22, 2002 at 21:01:59 +0200,
Gabor Faludi <falu(at)fits(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dan Langille 2002-10-23 04:15:13 Re: security rights per database DDL/DML connect
Previous Message David Bear 2002-10-23 01:00:57 line length line break issue