Thank you, Knut. I will file a JIRA issue.
 
Thanks,
Lily


From: Knut Anders Hatlen <Knut.Hatlen@Sun.COM>
To: derby-dev@db.apache.org
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 <lilywei@yahoo.com> 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