Skip site navigation (1) Skip section navigation (2)

Re: Deny creation of tables for a user

From: Terry Lee Tucker <terry(at)chosen-ones(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Deny creation of tables for a user
Date: 2008-04-23 11:14:16
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
On Wednesday 23 April 2008 06:46, Pascal Cohen wrote:
> Hello
> I am playing with security in Postgres
> And I would like to have a database that can be managed by a given user
> that could do almost anything but I would also have a user that can just
> handle what is created.
> I mean she could insert, update delete rows but not create tables.
> I did not find a way to revoke such thing. Is it possible ?
> Thanks!

Have you looked at GRANT?

Terry Lee Tucker
Turbo's IT Manager
Turbo, division of Ozburn-Hessey Logistics
2251 Jesse Jewell Pkwy NE
Gainesville, GA 30501
Tel: (336) 372-6812  Fax: (336) 372-6812  Cell: (336) 404-6987

In response to


pgsql-general by date

Next:From: Peter EisentrautDate: 2008-04-23 11:15:08
Subject: Re: initdb in 8.3
Previous:From: Tomasz OstrowskiDate: 2008-04-23 11:10:54
Subject: Re: Rapidly decaying performance repopulating a large table

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group