Postgres Pro
Downloads
Home   >   mailing lists

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

From John R Pierce
Subject Re: [SPAM] [GENERAL] AD(Active Directory) groups concepts in postgres
Date
Msg-id 15628109-8374-6aad-f78e-e5df304518a3@hogranch.com
Whole thread Raw
In response to Re: [SPAM] [GENERAL] AD(Active Directory) groups concepts in postgres  (PAWAN SHARMA <er.pawanshr0963@gmail.com>)
Responses Re: [SPAM] [GENERAL] AD(Active Directory) groups concepts in postgres  (PAWAN SHARMA <er.pawanshr0963@gmail.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Simon Riggs
Date:
Subject: Re: [GENERAL] Fastest simple key-value store, multiple writers, like Redis?
Next
From: James Bullock
Date:
Subject: Consider pgmodeler - Re: [GENERAL] Data Modeling Tools - Versionspecific to Postgres