[ 
https://issues.apache.org/jira/browse/DERBY-4272?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12793013#action_12793013
 ] 

Rick Hillegas edited comment on DERBY-4272 at 12/20/09 6:13 PM:
----------------------------------------------------------------

Also linking to DERBY-4487. We will be adding dblook support for SEQUENCEs and 
the USAGE privileges on them. We will need to wire those objects into the work 
being done on this issue. I believe this is the dependency ordering:

Sequences < Views,Triggers

      was (Author: rhillegas):
    Also linking to DERBY-4487. We will be adding dblook for SEQUENCEs and the 
USAGE privileges on them. We will need to wire those objects into the work 
being done on this issue. I believe this is the dependency ordering:

Sequences < Views,Triggers
  
> SQL Authorization Support for dblook
> ------------------------------------
>
>                 Key: DERBY-4272
>                 URL: https://issues.apache.org/jira/browse/DERBY-4272
>             Project: Derby
>          Issue Type: Improvement
>          Components: Tools
>         Environment: Any
>            Reporter: Hiranya Jayathilaka
>            Assignee: Hiranya Jayathilaka
>         Attachments: DERBY-4272-changes-u1.txt, DERBY-4272-changes-u2.txt, 
> DERBY-4272-changes-u3.txt, DERBY-4272-changes-u4.txt, 
> DERBY-4272-changes-u5.txt, DERBY-4272-changes-u6.txt, DERBY-4272-u1.patch, 
> DERBY-4272-u2.patch, DERBY-4272-u3.patch, DERBY-4272-u4.patch, 
> DERBY-4272-u5.patch, DERBY-4272-u6.patch, dhw-sample-1.sql, new.sql, old.sql
>
>
> Currently dblook suffers from two major shortcomings.
> 1. dblook doesn't take the object dependencies into consideration when 
> generating DDL scripts
> 2. dblook doesn't have any support for SQL authorization
> I intend to fix these two issues and improve dblook so that the DDL scripts 
> generated by dblook can be executed without errors under all conditions.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to