Skip site navigation (1) Skip section navigation (2)

Re: Inconsistent syntax in GRANT

From: Euler Taveira de Oliveira <eulerto(at)yahoo(dot)com(dot)br>
To: josh(at)agliodbs(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Inconsistent syntax in GRANT
Date: 2006-01-04 02:18:06
Message-ID: 20060104021806.21032.qmail@web32713.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
--- 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

Responses

pgsql-hackers by date

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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group