Re: Validating User Login Within Postgres

From: Sim Zacks <sim(at)compulab(dot)co(dot)il>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Validating User Login Within Postgres
Date: 2014-07-02 05:36:57
Message-ID: 53B39A79.3050503@compulab.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<html style="direction: ltr;">
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<style type="text/css">body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;"
bidimailui-detected-decoding-type="latin-charset" bgcolor="#FFFFFF"
text="#000000">
<div class="moz-cite-prefix">On 07/01/2014 06:03 PM, Rich Shepard
wrote:<br>
</div>
<blockquote cite="mid:alpine(dot)LNX(dot)2(dot)11(dot)1407010757070(dot)21028(at)localhost"
type="cite">On Tue, 1 Jul 2014, hubert depesz lubaczewski wrote:
<br>
<br>
<blockquote type="cite">That depends. For example - for system
that will have 5 users, and
<br>
requires strict security policies - it would make sense. On the
other
<br>
hand, for website, with thousands of users, putting them all as
actual
<br>
roles in Pg doesn't make much sense, and could potentially cause
problem.
<br>
</blockquote>
<br>
Hubert,
<br>
<br>
&nbsp; OK. This is not a Web-based application, but the users could
number in the
<br>
dozens.
<br>
</blockquote>
Using database user authentication is great for corporate use. If
you have an LDAP (or active directory) you can define the
authentication to use that. See the pg_hba file for details on
various authentication methods. <br>
<br>
Our application is written in python as well (desktop modules in
wxPython and web modules in django)&nbsp; and we use LDAP authentication.<br>
<br>
sim<br>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 1.6 KB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Arup Rakshit 2014-07-02 06:27:33 How can I replace the year of the created_at column with the current year dynamically ?
Previous Message Alex Hunsaker 2014-07-02 02:05:21 Re: pl/perl and recent perl versions - failing to load internal modules