Re: Every user has own database - how?

22 Mar 2007 17:01:20 -0700, Jaro :
> 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