Re: DEFAULT PRIVILEGES incorrect

Поиск
Список
Период
Сортировка
От Erwin Brandstetter
Тема Re: DEFAULT PRIVILEGES incorrect
Дата
Msg-id CAGHENJ78GVyYS-uhzB5d0Y_48so0GKNqEiCPTLTe56XHYb8NWA@mail.gmail.com
обсуждение исходный текст
Ответ на DEFAULT PRIVILEGES incorrect  (Erwin Brandstetter <brsaweda@gmail.com>)
Ответы Re: DEFAULT PRIVILEGES incorrect
Список pgadmin-support
Дерево обсуждения 
This bug has not been addressed in pgAdmin 1.22.0, yet.

If I run this as user postgres:

ALTER DEFAULT PRIVILEGES FOR ROLE foo IN SCHEMA test    GRANT SELECT ON TABLES    TO bar;

Then the SQL pane says (still as user postgres):

ALTER DEFAULT PRIVILEGES IN SCHEMA test
    GRANT SELECT ON TABLES
    TO bar;
Which is incorrect and misleading.

Regards

Erwin

On Thu, Aug 13, 2015 at 2:45 PM, Erwin Brandstetter <brsaweda@gmail.com> wrote:
The display of ALTER DEFAULT PRIVILEGES statements can be incorrect.

I reported this bug in 2013, but it seems like it never got through:
http://www.postgresql.org/message-id/528C2D00.6010905@falter.at

Details, with steps to reproduce:
https://redmine.postgresql.org/issues/694

Just tested with version 1.20 again and the situation seems unchanged.

Regards
Erwin


		
	


	

					

					





	

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