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

Поиск
Список
Период
Сортировка
От PAWAN SHARMA
Тема Re: [SPAM] [GENERAL] AD(Active Directory) groups concepts in postgres
Дата
Msg-id CAPgXFMSL8Vqqf9TXWutv1nnR=keX76+n1vcSnmJ=V7mK0SXt6A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [SPAM] [GENERAL] AD(Active Directory) groups concepts in postgres  (John R Pierce <pierce@hogranch.com>)
Ответы Re: [SPAM] [GENERAL] AD(Active Directory) groups concepts in postgres  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
Дерево обсуждения


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

  




В списке pgsql-general по дате отправления:

Предыдущее
От: James Bullock
Дата:
Сообщение: Consider pgmodeler - Re: [GENERAL] Data Modeling Tools - Versionspecific to Postgres
Следующее
От: "Sfiligoi, Igor"
Дата:
Сообщение: [GENERAL] PSQL 9.5 select for update locks too many rows when using numericinstead of int