db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lily Wei <lily...@yahoo.com>
Subject Question on inconsistent behavior for grant execute on procedure SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE
Date Wed, 01 Jul 2009 02:31:42 GMT
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.

    When using derby.properties file from mailjdbc tests, call SYSCS_UTIL.SYCS_INPLACE_COMPRESs_TABLE
is fine user 'BACKUP' with the following operation. Please see below:
ij version 10.3
ij> connect 'jdbc:derby:tpri;user=BACKUP;password=Backup';
ij> create table a (col1 int, col2 clob);
0 rows inserted/updated/deleted
ij> insert into a values (1, '1');
1 row inserted/updated/deleted
ij> insert into a values (2, '2');
1 row inserted/updated/deleted
ij> grant execute on procedure SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE to BACKUP;
0 rows inserted/updated/deleted
ij version 10.3
ij> connect 'jdbc:derby:tpri;user=BACKUP;password=Backup';
ij> call SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE('REFRESH','A',1,1,1);
0 rows inserted/updated/deleted              <<<====Operation successful=====

However, on 10.5, the same operation result ERROR 38000
ij> connect 'jdbc:derby:tpri;create=true;user=REFRESH;password=Refresh';
ij> create table a (col1 int, col2 clob);
0 rows inserted/updated/deleted
ij> insert into a values (1, '1');
1 row inserted/updated/deleted
ij> insert into a values (1, '2');
1 row inserted/updated/deleted
ij> grant execute on procedure SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE to BACKUP;
0 rows inserted/updated/deleted
ij> exit;

ij version 10.5
ij> connect 'jdbc:derby:tpri;user=BACKUP;password=Backup';
ij> call SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE('REFRESH','A',1,1,1);
ERROR 38000: The exception 'java.sql.SQLException: User 'BACKUP' can not perform
 the operation in schema 'REFRESH'.' was thrown while evaluating an expression.
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?


Thanks,
Lily

Thank you so much,
Lily


      
Mime
View raw message