[
https://issues.apache.org/jira/browse/DERBY-5578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13485004#comment-13485004
]
Rick Hillegas commented on DERBY-5578:
--------------------------------------
The following script demonstrates what the Reference Manual says:
o By default, only the DBO can run
SYSCS_UTIL.SYSCS_INVALIDATE_STORED_STATEMENTS.
o However, the DBO can grant other users the privilege to run this procedure.
connect 'jdbc:derby:memory:db;create=true;user=test_dbo';
-- turn on NATIVE authentication. won't take effect until you bounce the
database.
call syscs_util.syscs_create_user( 'test_dbo', 'test_dbopassword' );
call syscs_util.syscs_create_user( 'fred', 'fredpassword' );
-- bounce the database in order to turn on NATIVE authentication
connect 'jdbc:derby:memory:db;shutdown=true';
connect 'jdbc:derby:memory:db;user=test_dbo;password=test_dbopassword' as dbo;
-- the DBO can run this procedure
call syscs_util.syscs_invalidate_stored_statements();
connect 'jdbc:derby:memory:db;user=fred;password=fredpassword' as fred;
-- should fail because privilege has not been granted
call syscs_util.syscs_invalidate_stored_statements();
set connection dbo;
--grant privilege to fred;
grant execute on procedure syscs_util.syscs_invalidate_stored_statements to
fred;
set connection fred;
-- should work now that fred has been granted privilege
call syscs_util.syscs_invalidate_stored_statements();
> Provide a way to invalidate stored prepared statements
> ------------------------------------------------------
>
> Key: DERBY-5578
> URL: https://issues.apache.org/jira/browse/DERBY-5578
> Project: Derby
> Issue Type: Improvement
> Components: Services
> Reporter: Kathey Marsden
> Assignee: Mamta A. Satoor
> Fix For: 10.10.0.0
>
> Attachments: derby-5578-create.sql, DERBY5578_patch1_diff.txt,
> DERBY5578_patch2_diff.txt, derby-5578-upgrade.sql
>
>
> In various support situations I have seen problems with JDBC metadata stored
> prepared statements or trigger stored prepared statements that need to be
> invalidated. It would be nice to have a way to do this in the field. For
> 10.9 a stored procedure would make most sense, but it would be good to have
> something available in the release branches too.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
