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