Thread: Every user has own database - how?

Hello

How create something like this:

UserName: user1 (he's root db_user1)
DatabaseName db_user1

UserName: user2  (he's root db_user2)
DatabaseName db_user2


I'd like create several users and several databases, ever user should
be root only for own database

Could anybody show my SQL example how do this, please. I'm new in
postgresql, I've used mysql

--
Best regards

"Jaro" <jaro80@gmail.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

22 Mar 2007 17:01:20 -0700, Jaro <jaro80@gmail.com>:
> Hello
>
> How create something like this:
>
> UserName: user1 (he's root db_user1)
> DatabaseName db_user1
>
> UserName: user2  (he's root db_user2)
> DatabaseName db_user2
>
>
> I'd like create several users and several databases, ever user should
> be root only for own database
maybe superuser right is not needed, just make them db owners
like this:

create user john password 'apple';
create database john owner john;

create user mary password 'strawberry';
create database mary owner mary;



--
Filip Rembiałkowski