db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5329) Document who is allowed to run which system procedures/functions.
Date Thu, 14 Jul 2011 15:52:59 GMT

    [ 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

        

Mime
View raw message