--- Josh Berkus <josh(at)agliodbs(dot)com> escreveu:
> 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
> accept "SEQUENCE" there, since the optional object name works for all
> other objects? Is there some technical reason this is difficult to
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.
Euler Taveira de Oliveira
Yahoo! doce lar. Faça do Yahoo! sua homepage.
In response to
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|