On Fri, Feb 3, 2017 at 12:08 AM, John R Pierce <pierce@xxxxxxxxxxxx> 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......????????
