You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Rick Hillegas (JIRA)" <ji...@apache.org> on 2010/01/05 18:42:54 UTC
[jira] Commented: (DERBY-4502) Can't define view against system
table when SQL authorization is enabled--attempting to do so kills your
connection
[ 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.
Re: [jira] Commented: (DERBY-4502) Can't define view against system
table when SQL authorization is enabled--attempting to do so kills your
connection
Posted by Rick Hillegas <Ri...@Sun.COM>.
Myrna van Lunteren wrote:
> On Wed, Jan 6, 2010 at 9:30 AM, Rick Hillegas <Ri...@sun.com> wrote:
>
>> Hi Dag,
>>
>> Do you know the subversion spell for correcting a commit comment?
>>
>> Thanks,
>> -Rick
>>
>> Dag H. Wanvik wrote:
>>
>>> "Rick Hillegas (JIRA)" <ji...@apache.org> writes:
>>>
>>>
>>>
>>>> [
>>>> 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.
>>>>
>>>>
>>> The change log entry seems to have become garbled for this change; it
>>> just says "-d"..?
>>>
>>> Dag
>>>
>>>
>>
>
> svn propedit --revprop -r revision# svn:log
>
> Myrna
>
Thanks, Myrna. I think that did the trick.
Cheers,
-Rick
Re: [jira] Commented: (DERBY-4502) Can't define view against system
table when SQL authorization is enabled--attempting to do so kills your
connection
Posted by Myrna van Lunteren <m....@gmail.com>.
On Wed, Jan 6, 2010 at 9:30 AM, Rick Hillegas <Ri...@sun.com> wrote:
> Hi Dag,
>
> Do you know the subversion spell for correcting a commit comment?
>
> Thanks,
> -Rick
>
> Dag H. Wanvik wrote:
>>
>> "Rick Hillegas (JIRA)" <ji...@apache.org> writes:
>>
>>
>>>
>>> [
>>> 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.
>>>
>>
>> The change log entry seems to have become garbled for this change; it
>> just says "-d"..?
>>
>> Dag
>>
>
>
svn propedit --revprop -r revision# svn:log
Myrna
Re: [jira] Commented: (DERBY-4502) Can't define view against system
table when SQL authorization is enabled--attempting to do so kills your
connection
Posted by Rick Hillegas <Ri...@Sun.COM>.
Hi Dag,
Do you know the subversion spell for correcting a commit comment?
Thanks,
-Rick
Dag H. Wanvik wrote:
> "Rick Hillegas (JIRA)" <ji...@apache.org> writes:
>
>
>> [ 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.
>>
>
> The change log entry seems to have become garbled for this change; it
> just says "-d"..?
>
> Dag
>
Re: [jira] Commented: (DERBY-4502) Can't define view against system
table when SQL authorization is enabled--attempting to do so kills your
connection
Posted by "Dag H. Wanvik" <Da...@Sun.COM>.
"Rick Hillegas (JIRA)" <ji...@apache.org> writes:
> [ 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.
The change log entry seems to have become garbled for this change; it
just says "-d"..?
Dag