db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: grant/revoke improvements
Date Wed, 19 Jul 2006 22:41:32 GMT
Thanks Satheesh. I have added your concern to the wiki page describing 
the 10.2.0.4 snapshot.

Cheers,
-Rick

Satheesh Bandaram wrote:

>Hi Rick,
>
>It would be good to cover upgrade testing too. There is one known issue
>with upgrade and GRANT/REVOKE. I will file a JIRA entry for that. During
>database upgrade for a database from 10.1 to 10.2, the owner the
>database should change from peudo-user 'DBA' to actual authorizationID
>of the person performing the upgrade. This is not happening. There is
>mechanism in the upgrade already to perform this task, but seems to have
>a defect some where.
>
>I am working on two minor changes to Grant/Rekoke. They are:
>
>    * Raise a warning if sqlAuthorization is ON without have
>      authentication enabled.
>    * Drop permission descriptors when their object is dropped. Ex:
>      during drop table, drop all permission descriptors on that table.
>
>I will not be adding any more support to GRANT/REVOKE beyond this.
>
>Satheesh
>
>Rick Hillegas wrote:
>
>  
>
>>Thanks, Mamta. I have added your concern to the snapshot wiki page.
>>
>>Cheers,
>>-Rick
>>
>>Mamta Satoor wrote:
>>
>>    
>>
>>>Hi Rick,
>>> 
>>>Thanks for starting out this thread on grant/revoke improvement.
>>> 
>>>One plea I have for the community in general is more eyes on the
>>>patches I have been submitting for grant revoke recently (one can
>>>always go and review the patch that has been already committed and
>>>provide feedback).
>>> 
>>>As for testing, one particular area I am ansy about is statement
>>>caching and how statements in cache can invalidated if privilege
>>>changes after the statement has been cached. I have not done any work
>>>in that arena yet. Hopefully revoke privilege/drop table/drop
>>>view/drop routine work will take care of statement caching but I
>>>would like people to look out for this during their testing.
>>> 
>>>thanks,
>>>Mamta
>>> 
>>>ps I haven't done my share of looking into patches submmitted by
>>>others and hope to improve in that arena post 10.2 when there is more
>>>breathing time.
>>>
>>> 
>>>On 7/19/06, *Rick Hillegas* <Richard.Hillegas@sun.com
>>><mailto:Richard.Hillegas@sun.com>> wrote:
>>>
>>>    Hi Satheesh and Mamta,
>>>
>>>    Over the last month you have checked in a lot of great grant/revoke
>>>    improvements. If there's anything in particular which you want
>>>    users to
>>>    test-drive, feel free to list these items on the wiki page that
>>>    describes the 10.2.0.4 <http://10.2.0.4> snapshot:
>>>   
>>>http://wiki.apache.org/db-derby/TenTwoSnapshot#head-044f77b20b4cd15343e0b57416d4c6790d5bc3ae.
>>>
>>>
>>>    Thanks,
>>>    -Rick
>>>
>>>
>>>      
>>>
>>    
>>
>
>
>  
>


Mime
View raw message