[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
Re: Permissions on UU tables
On 03/23/10 00:23, Alexey Parshin wrote:
> Yeap. Usually that user is a DBA that created the database.
>
> On 23 March 2010 07:55, Ilya A. Volynets-Evenbakh
> <ilya@total-knowledge.com>wrote:
>
>
>> Aha. So the key here is that DML permissions on tables should be granted
>> to the user which owns procedures.
>>
Turns out one of procedures wasn't marked as security definer.
I guess the policy is
All public procedures are marked as "SECURITY DEFINER".
All internal procedures are _not_.
--
Ilya A. Volynets-Evenbakh
http://www.total-knowledge.com