Hi Mamta: Not a problem. I have created JIRA 4295 for this case. I am also trying to add the simple test case to GrantRevokeDDLTest. How do you run GrantRevokeDDLTest? Is it a good idea to add it in. This is diff I have so far:
Thank you so much for helping me look at this too, Lily ________________________________ From: Mamta Satoor <[email protected]> To: [email protected] Sent: Wednesday, July 1, 2009 11:35:15 AM Subject: Re: Question on inconsistent behavior for grant execute on procedure SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE 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 > >
derby4295.diff
Description: Binary data
