db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Satheesh Bandaram (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1532) Add GRANTOR column to primary key for SYSTABLEPERMS, SYSCOLPERMS and SYSROUTINEPERMS
Date Sun, 23 Jul 2006 19:50:15 GMT
    [ 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

        

Mime
View raw message