--- Josh Berkus <josh(at)agliodbs(dot)com> escreveu:

> However,
> GRANT SELECT ON TABLE table1 TO someuser; 
> ... works, while ....
> GRANT SELECT ON SEQUENCE table1_id_seq TO someuser;
> ... raises an error.
> 
> This is inconsistent.   Do people agree with me that the parser
> should 
> accept "SEQUENCE" there, since the optional object name works for all
> 
> other objects?  Is there some technical reason this is difficult to
> do?
> 
It should but it's not implemented yet. There is no difficulty in doing
it. But I want to propose the following idea: if some object depends on
another object and its type is 'DEPENDENCY_INTERNAL' we could
grant/revoke privileges automagically to it. Or maybe create another
type of dependency to do so.
Comments?


Euler Taveira de Oliveira
euler[at]yahoo_com_br


	



	
		
_______________________________________________________ 
Yahoo! doce lar. Faça do Yahoo! sua homepage. 
http://br.yahoo.com/homepageset.html 

In response to

• Inconsistent syntax in GRANT at 2006-01-04 01:19:41 from Josh Berkus

Responses

• Re: Inconsistent syntax in GRANT at 2006-01-04 19:41:36 from Josh Berkus

pgsql-hackers by date

Next:	From: Michael Glaesemann	Date: 2006-01-04 02:20:43
	Subject: Re: Deferrable UNIQUE INDEX?
Previous:	From: David Fetter	Date: 2006-01-04 01:45:13
	Subject: Deferrable UNIQUE INDEX?

pgsql-patches by date

Next:	From: Stephen Frost	Date: 2006-01-04 03:44:58
	Subject: TRUNCATE, VACUUM, ANALYZE privileges
Previous:	From: Josh Berkus	Date: 2006-01-04 01:19:41
	Subject: Inconsistent syntax in GRANT