[jira] Commented: (DERBY-1579) Remove SYS.SYSREQUIREDPERM from Derby 10.2. This was added for Grant Revoke functionality

2006-07-28 Thread Yip Ng (JIRA) 
[ 
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

2006-07-29 Thread Yip Ng (JIRA) 
[ 
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

2006-08-01 Thread Deepa Remesh (JIRA) 
[ 
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

2006-08-02 Thread Deepa Remesh (JIRA) 
[ 
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

2006-08-03 Thread Rick Hillegas (JIRA) 
[ 
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

2006-07-28 Thread Daniel John Debrunner 
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

2006-08-01 Thread Yip Ng 
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