[SQL] GRANT EXECUTE

2001-06-10 Thread Dmitry G. Mastrukov
Hi, All! IMHO it will be useful to have EXECUTE privilege on procedures. It may be realized through GRANT SELECT ON [procedure] since we cannot directly execute procedure in SQL. But anyway ability to restrict access to procedures seems good thing. What do you think about it? Dmitry -

Re: [SQL] Integrity and Inheritance

2001-06-10 Thread Stephan Szabo
On Sun, 10 Jun 2001, Tom Lane wrote: > Stephan Szabo <[EMAIL PROTECTED]> writes: > > One problem is that for update isn't supported across inheritance trees > > AFAICS and the triggers use for update for the appropriate locking. > > It's possible (maybe even likely) that this could be fixed wit

Re: [SQL] Integrity and Inheritance

2001-06-10 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > One problem is that for update isn't supported across inheritance trees > AFAICS and the triggers use for update for the appropriate locking. It's possible (maybe even likely) that this could be fixed with minimal work. I punted on it for 7.1 due to la