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 "Deepa Remesh (JIRA)" <de...@db.apache.org> on 2006/08/01 21:37:18 UTC
[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
Re: [jira] Commented: (DERBY-1579) Remove SYS.SYSREQUIREDPERM from Derby 10.2. This was added for Grant Revoke functionality
Posted by Yip Ng <yi...@gmail.com>.
Will do. =)
On 8/1/06, Deepa Remesh (JIRA) <de...@db.apache.org> 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
>
>
>