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