Re: How to setup PostgreSQL to work with libpam-pgsql/libnss-pgsql2?

Lists: pgsql-general
From: PMC OS <pmcos-support(at)freenet(dot)de>
To: PMC OS <pmcos-support(at)freenet(dot)de>,pgsql-general(at)postgresql(dot)org
Subject: Re: How to setup PostgreSQL to work with libpam-pgsql/libnss-pgsql2?
Date: 2010-08-24 19:53:21
Message-ID: c373801c0059b804007ca9fc2a071853@email.freenet.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

OK, now I can connect to the PostgreSQL Server but it is weird...

> -----Ursprüngliche Nachricht-----
> and in the pg_hba.conf
> local all postgres ident sameuser
> host system root 192.168.0.0/24 md5

I can not use "root" as the owner of the database...

Now I have created a user named "system" and changed from "root" to "system" is now working

Can someone tell me the command line, how to restrict the access to DB "system" to user "system" only?

Thanks

--

Exklusiv: Neue E-Mail-Adresse @iPhone.de jetzt verfügbar!
Sichern Sie sich jetzt ihre persönliche http://www.iphone.de/iphonemail/index.html?pid=10111947021