[ http://issues.apache.org/jira/browse/DERBY-1858?page=all ]
Mike Matrigali updated DERBY-1858: ---------------------------------- I looked at applying this patch, but it failed with the following warning, not sure if it is my environment or that the patch needs to be regenerated: m1_ibm142:52>pwd C:/p4/m1/opensource m1_ibm142:53>patch --dry-run -p0 -i c:/tmp/derby1858-trunk-diff01.txt patching file `java/engine/org/apache/derby/impl/sql/compile/CompilerContextImpl .java' patching file `java/engine/org/apache/derby/impl/sql/compile/DropSchemaNode.java ' patching file `java/engine/org/apache/derby/iapi/sql/compile/CompilerContext.jav a' patching file `java/engine/org/apache/derby/iapi/sql/conn/Authorizer.java' patching file `java/engine/org/apache/derby/iapi/sql/dictionary/StatementSchemaP ermission.java' Hunk #3 FAILED at 66. 1 out of 3 hunks FAILED -- saving rejects to java/engine/org/apache/derby/iapi/s ql/dictionary/StatementSchemaPermission.java.rej patching file `java/testing/org/apache/derbyTesting/functionTests/tests/lang/gra ntRevokeDDL2.sql' patching file `java/testing/org/apache/derbyTesting/functionTests/master/jdk16/g rantRevokeDDL2.out' patching file `java/testing/org/apache/derbyTesting/functionTests/master/grantRe vokeDDL2.out' > A schema can be dropped by a non-schema owner in SQL authorization mode > ----------------------------------------------------------------------- > > Key: DERBY-1858 > URL: http://issues.apache.org/jira/browse/DERBY-1858 > Project: Derby > Issue Type: Bug > Components: SQL > Affects Versions: 10.2.1.4, 10.3.0.0, 10.2.2.0 > Environment: Any > Reporter: Yip Ng > Assigned To: Yip Ng > Fix For: 10.2.2.0 > > Attachments: derby1858-trunk-diff01.txt, derby1858-trunk-stat01.txt > > > drop schema user2 restrict should fail since user3 does not own the schema > user2. > ij version 10.3 > ij> connect 'wombat;create=true' user 'user1' as user1; > WARNING 01J14: SQL authorization is being used without first enabling > authentication. > ij> connect 'wombat;create=true' user 'user2' as user2; > WARNING 01J01: Database 'wombat' not created, connection made to existing > database instead. > WARNING 01J14: SQL authorization is being used without first enabling > authentication. > ij(USER2)> create schema user2; > 0 rows inserted/updated/deleted > ij(USER2)> connect 'wombat;create=true' user 'user3' as user3; > WARNING 01J01: Database 'wombat' not created, connection made to existing > database instead. > WARNING 01J14: SQL authorization is being used without first enabling > authentication. > ij(USER3)> drop schema user2 restrict; > 0 rows inserted/updated/deleted > sysinfo: > ------------------ Java Information ------------------ > Java Version: 1.4.2_12 > Java Vendor: Sun Microsystems Inc. > Java home: c:\jdk142\jre > Java classpath: classes;. > OS name: Windows XP > OS architecture: x86 > OS version: 5.1 > Java user name: Yip > Java user home: C:\Documents and Settings\Yip > Java user dir: C:\work3\derby\trunk > java.specification.name: Java Platform API Specification > java.specification.version: 1.4 > --------- Derby Information -------- > JRE - JDBC: J2SE 1.4.2 - JDBC 3.0 > [C:\work3\derby\trunk\classes] 10.3.0.0 alpha - (446666) > ------------------------------------------------------ > ----------------- Locale Information ----------------- > Current Locale : [English/United States [en_US]] > Found support for locale: [de_DE] > version: 10.3.0.0 alpha - (446666) > Found support for locale: [es] > version: 10.3.0.0 alpha - (446666) > Found support for locale: [fr] > version: 10.3.0.0 alpha - (446666) > Found support for locale: [it] > version: 10.3.0.0 alpha - (446666) > Found support for locale: [ja_JP] > version: 10.3.0.0 alpha - (446666) > Found support for locale: [ko_KR] > version: 10.3.0.0 alpha - (446666) > Found support for locale: [pt_BR] > version: 10.3.0.0 alpha - (446666) > Found support for locale: [zh_CN] > version: 10.3.0.0 alpha - (446666) > Found support for locale: [zh_TW] > version: 10.3.0.0 alpha - (446666) > ------------------------------------------------------ -- 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
