>>> On Fri, Jun 13, 2008 at 11:06 AM, in message
Domiciano" <rafael(dot)domiciano(at)gmail(dot)com> wrote:
> So, there is no manner to define that the user can't do create or
> objects, but can create temp tables?
What we normally do is something like this.
create user dbowner password 'ownerpasswd';
create user db password 'normalpasswd';
create user dbviewer password 'viewerpasswd';
create database db with owner dbowner;
revoke create on database db from public;
revoke create on schema public from public;
grant create on schema public to dbowner;
set role dbowner;
Then we limit access to the given database to the appropriate users in
the pg_hba.conf file. The owner grants the desired rights to each
I hope this helps.
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2008-06-19 18:06:50|
|Subject: Re: Readline support in psql -- worked earlier for me |
|Previous:||From: Peter Kovacs||Date: 2008-06-19 17:40:00|
|Subject: Re: Readline support in psql -- worked earlier for me|