Search Postgresql Archives

Re: Every user has own database - how?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux