Postgres Pro
Downloads
Home   >   mailing lists

select only user - Mailing list pgsql-admin

From Jessica Richard
Subject select only user
Date
Msg-id 77335.88733.qm@web56407.mail.re3.yahoo.com
Whole thread Raw
Responses Re: select only user  ("Milen A. Radev" <milen@radev.net>)
List pgsql-admin
Tree view
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.

pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: postgresql in FreeBSD jails: proposal
Next
From: "Milen A. Radev"
Date:
Subject: Re: select only user