[
https://issues.apache.org/jira/browse/DERBY-5329?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13065341#comment-13065341
]
Rick Hillegas commented on DERBY-5329:
--------------------------------------
Thanks for the sample edits, Kim. The rrefstorejarinstall edits look great to
me.
Concerning rrefaltertablecompress: I agree that DERBY-1062 doesn't affect what
we should say here. I think it's worth pointing out that you need to be the
schema owner in order to compress a table. The following script output shows
this:
ij> connect
'jdbc:derby:memory:db;create=true;user=admin;password=adminpassword' as
admin_conn;
ij> create table t( a int );
0 rows inserted/updated/deleted
ij> call syscs_util.syscs_compress_table( 'ADMIN', 'T', 1 );
0 rows inserted/updated/deleted
ij> connect 'jdbc:derby:memory:db;user=alice;password=alicepassword' as
alice_conn;
ij(ALICE_CONN)> create table s( a int );
0 rows inserted/updated/deleted
ij(ALICE_CONN)> call syscs_util.syscs_compress_table( 'ALICE', 'S', 1 );
0 rows inserted/updated/deleted
ij(ALICE_CONN)> call syscs_util.syscs_compress_table( 'ADMIN', 'T', 1 );
ERROR 38000: The exception 'java.sql.SQLException: User 'ALICE' can not perform
the operation in schema 'ADMIN'.' was thrown while evaluating an expression.
ERROR 42507: User 'ALICE' can not perform the operation in schema 'ADMIN'.
I don't have any additional suggestions. The pattern you have established looks
good to me. Thanks.
> Document who is allowed to run which system procedures/functions.
> -----------------------------------------------------------------
>
> Key: DERBY-5329
> URL: https://issues.apache.org/jira/browse/DERBY-5329
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Kim Haase
> Attachments: rrefaltertablecompress.html, rrefstorejarinstall.html
>
>
> The 5th functional spec attached to DERBY-464 contains a table describing
> which system procedures/functions can only be run by the DBO and which can be
> run by everyone. I can't find this information in our user guides. It would
> be good to copy this information into the Reference Guide topics for each of
> these procedures/functions.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
