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

2017-02-02 Thread John R Pierce
On 2/2/2017 12:13 PM, PAWAN SHARMA wrote: For testing i have created > > 1:create user user1; 2:create user user2; 3:create group dba_group; > 4:grant dba_group to user1; 5:ALTER group dba_group CREATEDB > CREATEROLE; > > > but still user1 don't have createdb and createrole privilege, even he

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

2017-02-02 Thread PAWAN SHARMA
On Fri, Feb 3, 2017 at 12:47 AM, John R Pierce wrote: > On 2/2/2017 11:09 AM, PAWAN SHARMA wrote: > > > 1: Create User > 2:Create group > 3:Alter Group Add/Remove User's.. > > > create user user1; > create user user2; > create group group1; > grant group1 to

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

2017-02-02 Thread John R Pierce
On 2/2/2017 11:09 AM, PAWAN SHARMA wrote: 1: Create User 2:Create group 3:Alter Group Add/Remove User's.. create user user1; create user user2; create group group1; grant group1 to user1, user2; in fact in postgres, both users and groups are roles, the only distinction is in

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

2017-02-02 Thread PAWAN SHARMA
On Fri, Feb 3, 2017 at 12:08 AM, John R Pierce 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

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

2017-02-02 Thread John R Pierce
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?

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

2017-02-02 Thread Moreno Andreo
Hi Pawan, Il 02/02/2017 16:49, PAWAN SHARMA ha scritto: Hi All,

[GENERAL] AD(Active Directory) groups concepts in postgres

2017-02-02 Thread PAWAN SHARMA
Hi All, 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. -Pawan