db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lily Wei <lily...@yahoo.com>
Subject Re: Question on inconsistent behavior for grant execute on procedure SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE
Date Wed, 01 Jul 2009 18:41:20 GMT
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 <msatoor@gmail.com>
To: derby-dev@db.apache.org
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<lilywei@yahoo.com> wrote:
> 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
>
>



      
Mime
View raw message