db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deepa Remesh (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1579) Remove SYS.SYSREQUIREDPERM from Derby 10.2. This was added for Grant Revoke functionality
Date Tue, 01 Aug 2006 19:37:18 GMT
    [ 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

        

Mime
View raw message