[
https://issues.apache.org/jira/browse/DERBY-4502?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12796784#action_12796784
]
Rick Hillegas commented on DERBY-4502:
--------------------------------------
Committed derby-4502-01-aa-dummyUUID.diff at subversion revision 896146.
> Can't define view against system table when SQL authorization is
> enabled--attempting to do so kills your connection
> -------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-4502
> URL: https://issues.apache.org/jira/browse/DERBY-4502
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Reporter: Rick Hillegas
> Attachments: derby-4502-01-aa-dummyUUID.diff
>
>
> Derby fails on an NPE if you try to create the following view when
> authorization is turned on:
> create view v2( a ) as select tablename from sys.systables;
> The NPE occurs when the dependency manager trips across a dummy permission
> constructed on-the-fly. The dummy permission is created by
> PermissionsCacheable and is supposed to represent the implicit grant to
> PUBLIC of SELECT privilege on the system table. PermissionsCacheable doesn't
> bother to give the dummy permission a corresponding dummy UUID. The
> dependency manager falls down when trying to deference the null UUID of the
> dummy permission.
> The following script shows this problem:
> connect
> 'jdbc:derby:memory:dummy;create=true;user=test_dbo;password=test_dbopassword'
> as test_dbo_conn;
> connect 'jdbc:derby:memory:dummy;user=ruth;password=ruthpassword' as
> ruth_conn;
> create table t( b int );
> create view v1( a ) as select b from t;
> create view v2( a ) as select tablename from sys.systables;
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
