Postgres Pro
Downloads
Home   >   mailing lists

Re: [SPAM] [GENERAL] AD(Active Directory) groups concepts in postgres - Mailing list pgsql-general

From PAWAN SHARMA
Subject Re: [SPAM] [GENERAL] AD(Active Directory) groups concepts in postgres
Date
Msg-id CAPgXFMTDY7UP=kCjVj3HD_91Xv=0zX06i_oprw8AxZOunoVS9g@mail.gmail.com
Whole thread Raw
In response to Re: [SPAM] [GENERAL] AD(Active Directory) groups concepts in postgres  (John R Pierce <pierce@hogranch.com>)
Responses Re: [SPAM] [GENERAL] AD(Active Directory) groups concepts in postgres  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view

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


pgsql-general by date:

Previous
From: Rob Nikander
Date:
Subject: [GENERAL] Fastest simple key-value store, multiple writers, like Redis?
Next
From: Simon Riggs
Date:
Subject: Re: [GENERAL] Fastest simple key-value store, multiple writers, like Redis?