[ http://issues.apache.org/jira/browse/DERBY-1532?page=comments#action_12422934 ] Satheesh Bandaram commented on DERBY-1532: ------------------------------------------
I was trying to address this issue, but I found that system tables in question already have GRANTOR in the primary key. Functional spec needs updating. Here is what I tried: Note that column '3' is the GRANTOR column in all three system tables. ij> select cast(descriptor as char(50)) from sys.sysconglomerates i where conglomerateid='c065801d-0103-0e39-b8e7-00000010f010'; 1 -------------------------------------------------- UNIQUE BTREE (2, 4, 3) ij> select cast(descriptor as char(50)) from sys.sysconglomerates i where conglomerateid='787c0020-0103-0e39-b8e7-00000010f010' ; 1 -------------------------------------------------- UNIQUE BTREE (2, 4, 5, 3) ij> select cast(descriptor as char(50)) from sys.sysconglomerates i where conglomerateid='c851401a-0103-0e39-b8e7-00000010f010'; 1 -------------------------------------------------- UNIQUE BTREE (2, 4, 3) ij> select columnnumber, cast(columnname as char(10)) columnname from sys.syscolumns c, sys.systables t where c.referenceid=t.tableid and t.tablename='SYSCOLPERMS'; COLUMNNUMB&|COLUMNNAME ---------------------- 1 |COLPERMSID 6 |COLUMNS 2 |GRANTEE 3 |GRANTOR <==================== 4 |TABLEID 5 |TYPE 6 rows selected ij> select columnnumber, cast(columnname as char(10)) columnname from sys.syscolumns c, sys.systables t where c.referenceid=t.tableid and t.tablename='SYSTABLEPERMS' order by 1; COLUMNNUMB&|COLUMNNAME ---------------------- 1 |TABLEPERMS 2 |GRANTEE 3 |GRANTOR <============================ 4 |TABLEID 5 |SELECTPRIV 6 |DELETEPRIV 7 |INSERTPRIV 8 |UPDATEPRIV 9 |REFERENCES 10 |TRIGGERPRI ij> select columnnumber, cast(columnname as char(10)) columnname from sys.syscolumns c, sys.systables t where c.referenceid=t.tableid and t.tablename='SYSROUTINEPERMS' order by 1; COLUMNNUMB&|COLUMNNAME ---------------------- 1 |ROUTINEPER 2 |GRANTEE 3 |GRANTOR <=============== 4 |ALIASID 5 |GRANTOPTIO I will update functional spec to show correct primary key and also mention that Derby disallows revoking privileges from object owners. > Add GRANTOR column to primary key for SYSTABLEPERMS, SYSCOLPERMS and > SYSROUTINEPERMS > ------------------------------------------------------------------------------------ > > Key: DERBY-1532 > URL: http://issues.apache.org/jira/browse/DERBY-1532 > Project: Derby > Issue Type: Sub-task > Components: SQL > Reporter: Daniel John Debrunner > Assigned To: Satheesh Bandaram > Fix For: 10.2.0.0 > > -- 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
