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: 200804230714.16782.terry@chosen-ones.org (view raw or flat)
Thread:
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?
http://www.postgresql.org/docs/8.3/interactive/sql-grant.html


-- 
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
terry(at)turbocorp(dot)com
www.turbocorp.com

In response to

Responses

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-2014 The PostgreSQL Global Development Group