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  (Dave Page <dpage@pgadmin.org>)
Список 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 по дате отправления:
	
	

	
	

		
			

	        	

	       			Предыдущее
	    		

	    		
	От:
	Gabriel E. Sánchez Martínez

	Дата:
	



	Сообщение:
	Re: Copy & paste key commands not working correctly
 

	    	

	    
	    
	    
			

	        	

	       			Следующее
	    		

	    		
	От:
	Dave Page

	Дата:
	



	Сообщение:
	Re: DEFAULT PRIVILEGES incorrect