Re: Every user has own database - how?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jaro" <jaro80(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Every user has own database - how?
Date: 2007-03-27 03:33:45
Message-ID: 11019.1174966425@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Jaro" <jaro80(at)gmail(dot)com> writes:
> I'd like create several users and several databases, ever user should
> be root only for own database

Anyone who is superuser in any database can certainly override any
restrictions you might think to put on him. (Hint: he can get at
the filesystem.)

If you really wish to hand out superuser to people you don't entirely
trust, then give each of them their own installation ($PGDATA tree),
running under a Unix account that isn't shared with anything else.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-03-27 03:37:18 Re: [GENERAL] ERROR: out of shared memory
Previous Message Tom Lane 2007-03-27 03:29:45 Re: Strange result using transactions