Re: [SPAM] AD(Active Directory) groups concepts in postgres

On Fri, Feb 3, 2017 at 12:08 AM, John R Pierce <pierce(at)hogranch(dot)com> wrote:

> On 2/2/2017 8:24 AM, Moreno Andreo wrote:
>
>
> Can we use AD(Active Directory) groups concepts in postgres as we are
> using this concepts in SQL server.
>
> So, is there any possible to work with AD groups such as (IT-DBA,
> IT-APPS..etc ) in postgresql.
>
>
> Like this?
> https://wiki.postgresql.org/wiki/LDAP_Authentication_against_AD
>
>
> that handles authentication, but AFAIK, postgresql has no concept of
> Active Directory groups, only group roles defined within the postgres
> server. even if you're using AD for authentication, you still have to
> create roles in postgresql, and put these roles in groups.
>
> --
> john r pierce, recycling bits in santa cruz
>
>
Thanks John,

So, We need to follow below steps in such case:

1: Create User
2:Create group
3:Alter Group Add/Remove User's......????????