[ https://issues.apache.org/jira/browse/DERBY-1723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17435735#comment-17435735 ]
Zoe Zaldana commented on DERBY-1723: ------------------------------------- Wow its now October of 2021 and y'all still completely invading this poor woman's privacy without her knowledge that entire time. Its sickening that you can have full access of someone's phone like this... it's literally a beacon transmitting your exact location. Husband tried killing her and her 2 kids went to prison how'd you expect her to actually? And 10 yr restraining order on him finally gets divorce finalized and a man in a Gilley suit shows up in her friends wooded back yard the same week! This needs to be taken off IMMEDIATEY. Almost got them Killed!!!! I got to say is Karma and I hope she sues all involved. > Database owner revokes select privilege from a schema owner but owner is > still able to select > --------------------------------------------------------------------------------------------- > > Key: DERBY-1723 > URL: https://issues.apache.org/jira/browse/DERBY-1723 > Project: Derby > Issue Type: Bug > Components: SQL > Affects Versions: 10.2.1.6 > Environment: Sun JDK 1.4.2 > Reporter: Yip Ng > Priority: Major > > Database owner attempts to revoke select privilege from a schema owner's own > table but the owner later can still select from the revoked table. Behavior > is inconsistent. e.g.: > ij version 10.2 > ij> connect 'jdbc:derby:wombat;create=true' user 'user1' as user1; > WARNING 01J14: SQL authorization is being used without first enabling > authentication. > ij> connect 'jdbc:derby:wombat' user 'user2' as user2; > WARNING 01J14: SQL authorization is being used without first enabling > authentication. > ij(USER2)> create table tshared0 (i int); > 0 rows inserted/updated/deleted > ij(USER2)> -- db owner tries to revoke select access from schema owner user2 > set connection user1; > ij(USER1)> revoke select on user2.tshared0 from user2; > 0 rows inserted/updated/deleted > ij(USER1)> set connection user2; > ij(USER2)> select * from user2.tshared0; > I > ----------- > 0 rows selected > ij(USER2)> > sysinfo: > ------------------ Java Information ------------------ > Java Version: 1.4.2_12 > Java Vendor: Sun Microsystems Inc. > Java home: C:\Program Files\Java\j2re1.4.2_12 > Java classpath: derby.jar;derbytools.jar > 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\tests\derby-10.2.1.0\lib > 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\tests\derby-10.2.1.0\lib\derby.jar] 10.2.1.0 beta - (430903) > [C:\work3\derby\tests\derby-10.2.1.0\lib\derbytools.jar] 10.2.1.0 beta - > (430903) > ------------------------------------------------------ > ----------------- Locale Information ----------------- > Current Locale : [English/United States [en_US]] > Found support for locale: [de_DE] > version: 10.2.1.0 - (430903) > Found support for locale: [es] > version: 10.2.1.0 - (430903) > Found support for locale: [fr] > version: 10.2.1.0 - (430903) > Found support for locale: [it] > version: 10.2.1.0 - (430903) > Found support for locale: [ja_JP] > version: 10.2.1.0 - (430903) > Found support for locale: [ko_KR] > version: 10.2.1.0 - (430903) > Found support for locale: [pt_BR] > version: 10.2.1.0 - (430903) > Found support for locale: [zh_CN] > version: 10.2.1.0 - (430903) > Found support for locale: [zh_TW] > version: 10.2.1.0 - (430903) > ------------------------------------------------------ -- This message was sent by Atlassian Jira (v8.3.4#803005)