db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <banda...@gmail.com>
Subject Re: [jira] Commented: (DERBY-1543) Address two remaining issues with GRANT/REVOKE functionality: 1) Add warning when sqlAuthorization is on with authentication off 2) Drop permission descriptors when objects they cover are dropped.
Date Mon, 31 Jul 2006 17:06:19 GMT
Checked in fix for this... Dropping of table, column and routine
permission descriptors should only be attempted in SQL authorization
mode, as privilege system tables may not be present in soft-upgrade
mode.  Should pass now.

Satheesh
 
Mamta A. Satoor (JIRA) wrote:

>    [ http://issues.apache.org/jira/browse/DERBY-1543?page=comments#action_12424412 ]

>            
>Mamta A. Satoor commented on DERBY-1543:
>----------------------------------------
>
>Satheesh, I ran the upgrade test (upgradeTests/Upgrade_10_1_10_2.java) on a clean client
and the test failed. It has following stack trace
>SQLSTATE(XSAI2):ERROR XSAI2: The conglomerate (-1) requested does not exist.
>	at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:304)
>	at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(RAMTransaction.java:394)
>	at org.apache.derby.impl.store.access.RAMTransaction.openConglomerate(RAMTransaction.java:1315)
>	at org.apache.derby.impl.sql.catalog.TabInfoImpl.getRow(TabInfoImpl.java:794)
>	at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.dropTablePermDescriptor(DataDictionaryImpl.java:2509)
>	at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.dropAllTableAndColPermDescriptors(DataDictionaryImpl.java:2416)
>	at org.apache.derby.impl.sql.execute.DropTableConstantAction.executeConstantAction(DropTableConstantAction.java:219)
>	at org.apache.derby.impl.sql.execute.MiscResultSet.open(MiscResultSet.java:56)
>	at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:357)
>	at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1181)
>	at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:584)
>	at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:516)
>	at org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata_test.runTest(metadata_test.java:1192)
>	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>	at java.lang.reflect.Method.invoke(Method.java:324)
>	at org.apache.derbyTesting.functionTests.tests.upgradeTests.UpgradeTester.runMetadataTest(UpgradeTester.java:900)
>	at org.apache.derbyTesting.functionTests.tests.upgradeTests.UpgradeTester.runPhase(UpgradeTester.java:367)
>	at org.apache.derbyTesting.functionTests.tests.upgradeTests.UpgradeTester.runUpgradeTests(UpgradeTester.java:314)
>	at org.apache.derbyTesting.functionTests.tests.upgradeTests.Upgrade_10_1_10_2.main(Upgrade_10_1_10_2.java:43)
>
>Could this be related to your recent changes for dropping the permission descriptors associated
with a table? If not, may be I should open a new jira for upgrade test failure.
>
>ps I have been out of the loop for last couple days because my laptop died on Thursday.
So I hope this is not a known issue and there is already somebody working on it. 
>
>  
>
>>Address two remaining issues with GRANT/REVOKE functionality: 1) Add warning when
sqlAuthorization is on with authentication off 2) Drop permission descriptors when objects
they cover are dropped.
>>----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>>
>>                Key: DERBY-1543
>>                URL: http://issues.apache.org/jira/browse/DERBY-1543
>>            Project: Derby
>>         Issue Type: Sub-task
>>         Components: SQL
>>   Affects Versions: 10.2.0.0
>>           Reporter: Satheesh Bandaram
>>        Assigned To: Satheesh Bandaram
>>            Fix For: 10.2.0.0
>>
>>        Attachments: DERBY-1543.out, Derby1543.diff
>>
>>
>>Address two remaining sub-tasks:
>>Add warning when sqlAuthorization is on with authentication off: This is a precautionary
warning, since sqlAuthorization doesn't mean much without authentication being ON.
>>Drop permission descriptors when objects they cover are dropped: This applies to tables,
routines. When these objects are dropped, automatically drop their permisson descriptors.
>>    
>>
>
>  
>



Mime
View raw message