Search Postgresql Archives

Re: Security setup.

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

 



On 09/11/2011 02:58 PM, mgould@xxxxxxxxxxxxxxxxxxxx wrote:

Sim,

Thanks, our users can only get to the application(s) they have on their citrix menu. They are locked out of the servers otherwise. I haven't had a problem in the past 20 years with another db back end but I do think that on the whole I probably ought to consider a regular login. I have a few customers that wanted integrated logins to active directory which was easy with SQL Anywhere but I guess that I would have to use LDAP in order to get that to happen.

Best Regards

Michael Gould
Intermodal Software Solutions, LLC
904-226-0978

We use LDAP for authentication, but the user also has to be in the database. Using LDAP is as easy as adding something like this to your pg_hba.conf:
ldap "ldap://my-ldap-server.domain/Users;uid=;,ou=Users,dc=domain,dc=local";
Even with nobody being able to use their own client, with trust authentication, anybody could log in as anybody else without knowing their password

Sim

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[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