Security, IP and username restrictions - Mailing list pgsql-novice

From Tuomas Vanhanen
Subject Security, IP and username restrictions
Date
Msg-id IDENJKCIKHDPNNGMFPDKKEPDCAAA.Tuomas@TuomasVanhanen.com
Whole thread Raw
Responses Re: Security, IP and username restrictions  (Josh Berkus <josh@agliodbs.com>)
List pgsql-novice
Hi,

I´m very new to Postgres and I need some help with following:

Is it possible to restrict user rights by using both username and password
and IP address.

I have a situation where same user accessing the database from different
locations (IP addresses) must have different user rights. This means, that
same user in different locations would see different ammount of data. I know
I can build this easily to the web based front-end, but I´d like to make the
restriction in Postgres too.

thanks!

-Tuomas



pgsql-novice by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Migration from MSSQL to PGSQL
Next
From: "Jules Alberts"
Date:
Subject: maximum size of psql query file