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

select only user

From: Jessica Richard <rjessil(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: select only user
Date: 2008-01-17 14:30:37
Message-ID: 77335.88733.qm@web56407.mail.re3.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
I created a user and granted only "select" to this user so that  this user can only select the tables on a production system. But by default, this user can also CREATE TABLE successfully....

How can I revoke this "create table" privilege (and possible others) and limit this user to only the permissions granted by me?

Thanks,
Jessica

       
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile.  Try it now.

Responses

pgsql-admin by date

Next:From: Stephen FrostDate: 2008-01-17 14:37:29
Subject: Re: [ADMIN] postgresql in FreeBSD jails: proposal
Previous:From: Dave PageDate: 2008-01-17 13:58:36
Subject: Re: [ADMIN] postgresql in FreeBSD jails: proposal

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