db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject [Fwd: Grant and Revoke, Part I ... DERBY-464...]
Date Tue, 06 Dec 2005 16:13:50 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<body bgcolor="#ffffff" text="#000000">
I just attached Grant and Revoke, Part I patch to Jira entry.
(DERBY-464) This implements following items I listed in the previous
message. Some notes on the implementation so far:<br>
  <li>dblook needs to be enhanced to emit DDL for grant statements.</li>
  <li>I am working on a JUnit based test suite with many more tests.
Will submit that along with Part II.</li>
  <li>I see some implementation improvements possible with the current
patch. It should be possible to combine several new nodes being added,
to reduce number of nodes and hence foot print. Also, the patch adds a
Java object to new system tables. While Derby already has some java
objects in its system tables, I think, we should discourage adding new
java objects to catalogs. Since Java objects can't be used in SQL
easily, this makes metadata harder to use. I will explore rewriting
SYSCOLPERMS and SYSREQUIREDPERM to not use FormattableBitSet type. I
believe this can be done by having multiple entries in these catalogs
for each column referenced.</li>
  <li>I will update specification to include schema for new system
Let me know if anyone has any comments. I will work on DML support next.<br>

View raw message