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
