Home Projects Jobs Clientele Contact


[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

Authoright © Total Knowledge: 2001-2008