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
