Re: [HACKERS] USER Profiles for PostgreSQL

Hi John,

How those application accounts get recognized in database?

Let say App_user1 authenticated through application ,after that how the
App_user1 get access to DB?

can you please provide more information ,how the app users are accessing
database ?

Thanks,
Chiranjeevi

On Tue, Sep 19, 2017 at 3:45 PM, John R Pierce <pierce(at)hogranch(dot)com> wrote:

> On 9/19/2017 12:33 PM, chiru r wrote:
>
>> Yes, LDAP will do. However we need to sync the user accounts and groups
>> between AD and PG servers.and then AD profiles will apply to PG user
>> accounts for authentication.
>>
>>
> if you're using LDAP from the AD servers to authenticate, whats to sync?
>
>
> my database servers, the only 'users' connecting to them directly are the
> database administrators... the applications connect with application
> accounts, and if more security is required, these use certificates, or they
> use unix 'ident' local connections.
>
>
>
> --
> john r pierce, recycling bits in santa cruz
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>