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
