Re: PATCH: Ticket#99: Support for Default Privileges

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: PATCH: Ticket#99: Support for Default Privileges
Дата
Msg-id l2o937d27e11004270843u8475a15fk47d36628bd7f2466@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PATCH: Ticket#99: Support for Default Privileges  (Dave Page <dpage@pgadmin.org>)
Список pgadmin-hackers
Apologies - I forgot to attach the screenshots.

On Tue, Apr 27, 2010 at 1:58 PM, Dave Page <dpage@pgadmin.org> wrote:
> On Tue, Apr 27, 2010 at 10:02 AM, Ashesh Vashi
> <ashesh.vashi@enterprisedb.com> wrote:
>> Hi Dave,
>> Please find the updated patch.
>> It has all the changes - as you suggested.
>
> Close - but not quite there :-)
>
> - The listview that lists the privileges is still a fixed height, and
> on Mac, it pushes the TRIGGER privilege below the bottom of the
> control area. Please see the two attached screenshots. If you make the
> listview the variable height component (as it is on the privileges
> tab, it'll make sizing work properly.
>
> - The listview columns are still too small by default, as can be seen
> in the screenshot. Compare them to the sizes of the equivalent columns
> on the 'Privileges' tab.
>
> - TABLES, SEQUENCES and FUNCTIONS are still in upper case, and not init-capped.
>
> - The labels in the properties list view shouldn't have each work
> init-capped (and we can shorten them a little) - eg. "Default
> Privileges On Tables" should be "Default table ACL" (we use ACL
> already in the list).
>
> - There is no blank line between the table definition and the first
> ALTER DEFAULT... statement in the SQL pane, eg.:
>
> =====
> CREATE DATABASE postgres
>  WITH OWNER = postgres
>       ENCODING = 'UTF8'
>       TABLESPACE = pg_default
>       LC_COLLATE = 'C'
>       LC_CTYPE = 'C'
>       CONNECTION LIMIT = -1;
> ALTER DEFAULT PRIVILEGES
>    GRANT INSERT, SELECT, UPDATE, DELETE, TRUNCATE, REFERENCES,
> TRIGGER ON TABLES
>    TO postgres;
>
> ALTER DEFAULT PRIVILEGES
>    GRANT INSERT, SELECT, UPDATE, DELETE, TRUNCATE, REFERENCES,
> TRIGGER ON TABLES
>    TO public;
>
> ALTER DEFAULT PRIVILEGES
>    GRANT SELECT, UPDATE, USAGE ON SEQUENCES
>    TO postgres;
> =====
>
> Otherwise, it's looks like it's now working as expected :-)
>
> --
> Dave Page
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise Postgres Company
>



--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company

Вложения

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

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: PATCH: Ticket#99: Support for Default Privileges
Следующее
От: Ashesh Vashi
Дата:
Сообщение: Re: PATCH: Ticket#99: Support for Default Privileges