Re: [HACKERS] Inconsistent syntax in GRANT

2006-01-05 Thread Bruce Momjian
Josh Berkus wrote: > Euler, > > > 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. O

Re: [HACKERS] Inconsistent syntax in GRANT

2006-01-04 Thread Josh Berkus
Euler, > 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 o

Re: [HACKERS] Inconsistent syntax in GRANT

2006-01-03 Thread Euler Taveira de Oliveira
--- Josh Berkus 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 th

[HACKERS] Inconsistent syntax in GRANT

2006-01-03 Thread Josh Berkus
Folks, Just got tripped up by this: GRANT SELECT ON table1 TO someuser; GRANT SELECT ON table1_id_seq TO someuser; both work However, GRANT SELECT ON TABLE table1 TO someuser; ... works, while GRANT SELECT ON SEQUENCE table1_id_seq TO someuser; ... raises an error. This is inconsiste