On Fri, Feb 3, 2017 at 12:47 AM, John R Pierce <pierce@xxxxxxxxxxxx> wrote:
On 2/2/2017 11:09 AM, PAWAN SHARMA wrote:
1: Create User2:Create group3: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;
2:create user user2;
3:create group dba_group;
4:grant dba_group to user1;
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..?
.
