db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew McIntyre (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-1579) Remove SYS.SYSREQUIREDPERM from Derby 10.2. This was added for Grant Revoke functionality
Date Wed, 09 Aug 2006 20:59:17 GMT
     [ http://issues.apache.org/jira/browse/DERBY-1579?page=all ]

Andrew McIntyre updated DERBY-1579:
-----------------------------------

    Derby Info:   (was: [Patch Available])

I believe it has been discussed that the intent with the patch available checkbox is that
once the patch has been applied, or if the patch is withdrawn from consideration, the patch
available checkbox is unselected to indicate that there is no longer a patch with review pending
for this issue.

Now that its got my attention, I'll go through and check the state of the checkbox for other
closed issues.

> 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

        

Mime
View raw message