From: Jessica Richard <rjessil@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: select only user
Date: Thu, 17 Jan 2008 06:30:37 -0800 (PST)
Message-ID: <77335.88733.qm@web56407.mail.re3.yahoo.com> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: rjessil@yahoo.com
Subject: Re: select only user
In-Reply-To: <77335.88733.qm@web56407.mail.re3.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox