Hi Lily, While you enter a jira, I will try to see if I can figure what is going on this change in behavior.
thanks, Mamta On Wed, Jul 1, 2009 at 6:29 AM, Lily Wei<[email protected]> wrote: > Thank you, Knut. I will file a JIRA issue. > > Thanks, > Lily > > ________________________________ > From: Knut Anders Hatlen <[email protected]> > To: [email protected] > Sent: Wednesday, July 1, 2009 1:35:23 AM > Subject: Re: Question on inconsistent behavior for grant execute on > procedure SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE > > Lily Wei <[email protected]> writes: > >> Hi: >> I need your help on SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE. >> >> I am seeing inconsistent behavior for grant execute on procedure >> SYSCS_UTIL.SYSCS_INPLACE_COMPRESS TABLE between 10.3 and 10.5. >> > > [...] > >> ERROR 42507: User 'BACKUP' can not perform the operation in schema >> 'REFRESH'. >> <<<====Operation result with ERROR 38000 >> >> Is there a way for me to avoid ERROR 38000 on 10.5? > > Hi Lily, > > It looks like only the owner of the schema (the user who created it) in > which the table lives is allowed to call > SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE now. I think this is an > unintended side-effect of DERBY-1062. Please file a JIRA issue. > > -- > Knut Anders > >
