[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
Re: Permissions on UU tables
That's the point :)
On 23 March 2010 17:34, Ilya A. Volynets-Evenbakh
<ilya@total-knowledge.com>wrote:
> 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
>
>
--
Alexey Parshin,
http://www.sptk.net