Postgres Pro
Downloads
Home   >   mailing lists

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

From PMC OS
Subject Re: How to setup PostgreSQL to work with libpam-pgsql/libnss-pgsql2?
Date
Msg-id c373801c0059b804007ca9fc2a071853@email.freenet.de
Whole thread Raw
In response to How to setup PostgreSQL to work with libpam-pgsql/libnss-pgsql2?  (PMC OS <pmcos-support@freenet.de>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: PMC OS
Date:
Subject: How to setup PostgreSQL to work with libpam-pgsql/libnss-pgsql2?
Next
From: Craig Ringer
Date:
Subject: Re: How to setup PostgreSQL to work with libpam-pgsql/libnss-pgsql2?