[jira] Commented: (DERBY-1579) Remove SYS.SYSREQUIREDPERM from Derby 10.2. This was added for Grant Revoke functionality
[ http://issues.apache.org/jira/browse/DERBY-1579?page=comments#action_12424141 ] Yip Ng commented on DERBY-1579: --- I have a patch available, running derbyall suite now. Will post the patch as soon as regression completes successfully. > Remove SYS.SYSREQUIREDPERM from Derby 10.2. This was added for Grant Revoke > functionality > - > > Key: DERBY-1579 > URL: http://issues.apache.org/jira/browse/DERBY-1579 > Project: Derby > Issue Type: Improvement > Components: SQL >Affects Versions: 10.2.0.0 >Reporter: Mamta A. Satoor > Assigned To: Yip Ng >Priority: Minor > Fix For: 10.2.0.0 > > > With the Grant Revoke functionality. Derby engine needs to keep track of > view/constraint/trigger's dependencies on various privileges. > SYS.SYSREQUIREDPERM table was added for this purpose. But these depdencies > can be mantained using the existing Dependency Manager. I have done quite a > bit of work using Dependency Manager for Grant Revoke and do not see a need > for SYS.SYSREQUIREDPERM. Before 10.2 release, we should drop > SYS.SYSREQUIREDPERM from the Derby code and update the Grant/Revoke > functional spec accordingly. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1579) Remove SYS.SYSREQUIREDPERM from Derby 10.2. This was added for Grant Revoke functionality
[ http://issues.apache.org/jira/browse/DERBY-1579?page=comments#action_12424302 ] Yip Ng commented on DERBY-1579: --- derbyall ran successfully with this patch. > Remove SYS.SYSREQUIREDPERM from Derby 10.2. This was added for Grant Revoke > functionality > - > > Key: DERBY-1579 > URL: http://issues.apache.org/jira/browse/DERBY-1579 > Project: Derby > Issue Type: Improvement > Components: SQL >Affects Versions: 10.2.0.0 >Reporter: Mamta A. Satoor > Assigned To: Yip Ng >Priority: Minor > Fix For: 10.2.0.0 > > Attachments: derby1579trunkdiff01.txt, derby1579trunkstat01.txt > > > With the Grant Revoke functionality. Derby engine needs to keep track of > view/constraint/trigger's dependencies on various privileges. > SYS.SYSREQUIREDPERM table was added for this purpose. But these depdencies > can be mantained using the existing Dependency Manager. I have done quite a > bit of work using Dependency Manager for Grant Revoke and do not see a need > for SYS.SYSREQUIREDPERM. Before 10.2 release, we should drop > SYS.SYSREQUIREDPERM from the Derby code and update the Grant/Revoke > functional spec accordingly. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1579) Remove SYS.SYSREQUIREDPERM from Derby 10.2. This was added for Grant Revoke functionality
[ http://issues.apache.org/jira/browse/DERBY-1579?page=comments#action_12424985 ] Deepa Remesh commented on DERBY-1579: - I went through this patch and it looks good to me. With this patch, I confirmed that SYS.SYSREQUIREDPERM table does not get created. However, the patch does not apply cleanly to the latest codeline and needs to be updated. Some of the master files have conflicts. Yip, can you please post an updated patch for this? > Remove SYS.SYSREQUIREDPERM from Derby 10.2. This was added for Grant Revoke > functionality > - > > Key: DERBY-1579 > URL: http://issues.apache.org/jira/browse/DERBY-1579 > Project: Derby > Issue Type: Improvement > Components: SQL >Affects Versions: 10.2.0.0 >Reporter: Mamta A. Satoor > Assigned To: Yip Ng >Priority: Minor > Fix For: 10.2.0.0 > > Attachments: derby1579trunkdiff01.txt, derby1579trunkstat01.txt > > > With the Grant Revoke functionality. Derby engine needs to keep track of > view/constraint/trigger's dependencies on various privileges. > SYS.SYSREQUIREDPERM table was added for this purpose. But these depdencies > can be mantained using the existing Dependency Manager. I have done quite a > bit of work using Dependency Manager for Grant Revoke and do not see a need > for SYS.SYSREQUIREDPERM. Before 10.2 release, we should drop > SYS.SYSREQUIREDPERM from the Derby code and update the Grant/Revoke > functional spec accordingly. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1579) Remove SYS.SYSREQUIREDPERM from Derby 10.2. This was added for Grant Revoke functionality
[ http://issues.apache.org/jira/browse/DERBY-1579?page=comments#action_12425246 ] Deepa Remesh commented on DERBY-1579: - I ran derbyall using Sun jdk 1.4.2 on Windows XP with the updated patch 'derby1579trunkdiff02.txt'. I am seeing one diff in jdbcapi/XATest.java in derbynetclientmats framework: *** Start: XATest jdk1.4.2_06 DerbyNetClient derbynetclientmats:derbynetclientmats 2006-08-01 20:04:26 *** 52a53 > (1 |PREPARED |false |APP |UserTransaction 54d54 < (1 |PREPARED |false |APP |UserTransaction Test Failed. *** End: XATest jdk1.4.2_06 DerbyNetClient derbynetclientmats:derbynetclientmats 2006-08-01 20:04:48 *** The diff looks like an ordering issue and I don't see how it could be related to this patch. However, I am seeing the diff only with this patch and not seeing it in a fresh codeline. It would be good if someone else can run this test with the patch to confirm this. Thanks. > Remove SYS.SYSREQUIREDPERM from Derby 10.2. This was added for Grant Revoke > functionality > - > > Key: DERBY-1579 > URL: http://issues.apache.org/jira/browse/DERBY-1579 > Project: Derby > Issue Type: Improvement > Components: SQL >Affects Versions: 10.2.0.0 >Reporter: Mamta A. Satoor > Assigned To: Yip Ng >Priority: Minor > Fix For: 10.2.0.0 > > Attachments: derby1579trunkdiff01.txt, derby1579trunkdiff02.txt, > derby1579trunkstat01.txt, derby1579trunkstat02.txt > > > With the Grant Revoke functionality. Derby engine needs to keep track of > view/constraint/trigger's dependencies on various privileges. > SYS.SYSREQUIREDPERM table was added for this purpose. But these depdencies > can be mantained using the existing Dependency Manager. I have done quite a > bit of work using Dependency Manager for Grant Revoke and do not see a need > for SYS.SYSREQUIREDPERM. Before 10.2 release, we should drop > SYS.SYSREQUIREDPERM from the Derby code and update the Grant/Revoke > functional spec accordingly. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1579) Remove SYS.SYSREQUIREDPERM from Derby 10.2. This was added for Grant Revoke functionality
[ http://issues.apache.org/jira/browse/DERBY-1579?page=comments#action_12425538 ] Rick Hillegas commented on DERBY-1579: -- I'm having difficulty applying this patch (dery1579trunkdiff02.txt). Are there special instructions for applying this patch? I'm stumbing early on: rick_sun mainline (1.4) > svn_patch ~/junk/derby1579trunkdiff02.txt (Stripping trailing CRs from patch.) patching file java/engine/org/apache/derby/impl/sql/catalog/DataDictionaryImpl.java Reversed (or previously applied) patch detected! Assume -R? [n] > Remove SYS.SYSREQUIREDPERM from Derby 10.2. This was added for Grant Revoke > functionality > - > > Key: DERBY-1579 > URL: http://issues.apache.org/jira/browse/DERBY-1579 > Project: Derby > Issue Type: Improvement > Components: SQL >Affects Versions: 10.2.0.0 >Reporter: Mamta A. Satoor > Assigned To: Yip Ng >Priority: Minor > Fix For: 10.2.0.0 > > Attachments: derby1579trunkdiff01.txt, derby1579trunkdiff02.txt, > derby1579trunkstat01.txt, derby1579trunkstat02.txt > > > With the Grant Revoke functionality. Derby engine needs to keep track of > view/constraint/trigger's dependencies on various privileges. > SYS.SYSREQUIREDPERM table was added for this purpose. But these depdencies > can be mantained using the existing Dependency Manager. I have done quite a > bit of work using Dependency Manager for Grant Revoke and do not see a need > for SYS.SYSREQUIREDPERM. Before 10.2 release, we should drop > SYS.SYSREQUIREDPERM from the Derby code and update the Grant/Revoke > functional spec accordingly. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
Re: [jira] Commented: (DERBY-1579) Remove SYS.SYSREQUIREDPERM from Derby 10.2. This was added for Grant Revoke functionality
Yip Ng (JIRA) wrote: > [ > http://issues.apache.org/jira/browse/DERBY-1579?page=comments#action_12424141 > ] > > Yip Ng commented on DERBY-1579: > --- > > I have a patch available, running derbyall suite now. Will post the patch as > soon as regression completes successfully. Feel free to submit patches before the tests have passed, allows others to see it earlier. Dan.
Re: [jira] Commented: (DERBY-1579) Remove SYS.SYSREQUIREDPERM from Derby 10.2. This was added for Grant Revoke functionality
Will do. =)On 8/1/06, Deepa Remesh (JIRA)wrote: [ http://issues.apache.org/jira/browse/DERBY-1579?page=comments#action_12424985 ]Deepa Remesh commented on DERBY-1579: -I went through this patch and it looks good to me. With this patch, I confirmed that SYS.SYSREQUIREDPERM table does not get created. However, the patch does not apply cleanly to the latest codeline and needs to be updated. Some of the master files have conflicts. Yip, can you please post an updated patch for this? > Remove SYS.SYSREQUIREDPERM from Derby 10.2. This was added for Grant Revoke functionality> -> > Key: DERBY-1579> URL: http://issues.apache.org/jira/browse/DERBY-1579> Project: Derby> Issue Type: Improvement > Components: SQL>Affects Versions: 10.2.0.0>Reporter: Mamta A. Satoor> Assigned To: Yip Ng>Priority: Minor > Fix For: 10.2.0.0>> Attachments: derby1579trunkdiff01.txt, derby1579trunkstat01.txt>>> With the Grant Revoke functionality. Derby engine needs to keep track of view/constraint/trigger's dependencies on various privileges. SYS.SYSREQUIREDPERM table was added for this purpose. But these depdencies can be mantained using the existing Dependency Manager. I have done quite a bit of work using Dependency Manager for Grant Revoke and do not see a need for SYS.SYSREQUIREDPERM. Before 10.2 release, we should drop SYS.SYSREQUIREDPERM from the Derby code and update the Grant/Revoke functional spec accordingly.--This message is automatically generated by JIRA.- If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa-For more information on JIRA, see: http://www.atlassian.com/software/jira