Re: Re: Group role not shown in properties > Default Privileges after adding it

Поиск
Список
Период
Сортировка
От Aren Cambre
Тема Re: Re: Group role not shown in properties > Default Privileges after adding it
Дата
Msg-id CAA1mBrpHbTRK4+MPifhCd=Z1xTSzaFNap7ARgUL8vY4T40urYg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Re: Group role not shown in properties > Default Privileges after adding it  (Dave Page <dpage@pgadmin.org>)
Ответы Re: Re: Group role not shown in properties > Default Privileges after adding it
Re: Group role not shown in properties > Default Privileges after adding it
Список pgadmin-support

This doesn't make sense. If I create a login role, it should show up here and allow me to assign it to arbitrary tables.

That's intentional (and configurable): see http://www.pgadmin.org/support/faq.php#UserPrivileges

Argh, thanks. Now I remember running into this before.

This needs to be more clearly explained in the UI. I am an IT pro, and I totally understand the best practice of assigning groups and not users. But if you are imposing this rule on us, you need to make this clear in the UI and not send users on a wild goose chase. In this case, neither the UI nor the pgAdmin docs clearly explained this. I'd have to troll through a FAQ to figure it out.

In my case, I am the only user of the DB, and there are a small number of accounts, so it's much easier for me to directly assign users.

In the end, this is just a recommended practice, not a Postgres rule. The UI should not make our lives miserable if we don't want to follow the recommendation.

Aren

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

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: Re: Group role not shown in properties > Default Privileges after adding it
Следующее
От: stokks
Дата:
Сообщение: make a dynamic URL shorter? (problem updating database)