You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Rick Hillegas (JIRA)" <ji...@apache.org> on 2009/12/20 19:14:18 UTC

[jira] Issue Comment Edited: (DERBY-4272) SQL Authorization Support for dblook

    [ 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.