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

On Fri, Feb 3, 2017 at 12:47 AM, John R Pierce <pierce(at)hogranch(dot)com> 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 user1, user2;
>
>
> in fact in postgres, both users and groups are roles, the only distinction
> is in how they are used. CREATE USER xxxx is exactly the same as CREATE
> ROLE xxxx WITH LOGIN;
>
>
> --
> john r pierce, recycling bits in santa cruz
>
>

Hi John

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 is
assigned to dba_group which having both the privileges..?
.