Return-Path: 
 <derby-dev-return-81798-apmail-db-derby-dev-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-dev-archive@www.apache.org
Received: (qmail 20268 invoked from network); 7 Oct 2010 09:27:56 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 7 Oct 2010 09:27:56 -0000
Received: (qmail 10728 invoked by uid 500); 7 Oct 2010 09:27:56 -0000
Delivered-To: apmail-db-derby-dev-archive@db.apache.org
Received: (qmail 10557 invoked by uid 500); 7 Oct 2010 09:27:56 -0000
Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:derby-dev-help@db.apache.org>
List-Unsubscribe: <mailto:derby-dev-unsubscribe@db.apache.org>
List-Post: <mailto:derby-dev@db.apache.org>
List-Id: <derby-dev.db.apache.org>
Reply-To: <derby-dev@db.apache.org>
Delivered-To: mailing list derby-dev@db.apache.org
Received: (qmail 10542 invoked by uid 99); 7 Oct 2010 09:27:55 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 07 Oct 2010 09:27:55 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=10.0
	tests=ALL_TRUSTED,WEIRD_QUOTING
X-Spam-Check-By: apache.org
Received: from [140.211.11.22] (HELO thor.apache.org) (140.211.11.22)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 07 Oct 2010 09:27:53 +0000
Received: from thor (localhost [127.0.0.1])
	by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o979RVSD025200
	for <derby-dev@db.apache.org>; Thu, 7 Oct 2010 09:27:31 GMT
Message-ID: <2561717.23191286443651362.JavaMail.jira@thor>
Date: Thu, 7 Oct 2010 05:27:31 -0400 (EDT)
From: "Knut Anders Hatlen (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-4838) dblook outputs GRANT statements for
 ignored tables
In-Reply-To: <9136571.22731286441552388.JavaMail.jira@thor>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394
X-Virus-Checked: Checked by ClamAV on apache.org


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

Knut Anders Hatlen commented on DERBY-4838:
-------------------------------------------

This bug also makes dblook_test and dblook_test_territory output the following error:

FAILED: to execute cmd from DDL script:
GRANT SELECT("'Single' and ""double"" quoted column name") ON "'Single' and ""double"" quoted schema name"."'Single' and ""double"" quoted table name" TO "SOMEONE"
Schema ''Single' and "double" quoted schema name' does not exist

The tests try to execute the DDL statements produced by dblook, but fail because the table in the GRANT statement is an ignored table, and the corresponding CREATE TABLE statement has not been executed. When this bug is fixed, the GRANT statement should not be printed and executed, and the error message must be removed from the test canons.

> dblook outputs GRANT statements for ignored tables
> --------------------------------------------------
>
>                 Key: DERBY-4838
>                 URL: https://issues.apache.org/jira/browse/DERBY-4838
>             Project: Derby
>          Issue Type: Bug
>          Components: Tools
>    Affects Versions: 10.7.0.0
>            Reporter: Knut Anders Hatlen
>
> dblook has an option that allows the user to specify which tables to produce DDL statements for:
>  	-t <tableOne> <tableTwo> ... to specify a list of tables for which
>  	 the DDL will be generated; any tables not in the list will be ignored.
> However, GRANT statements for privileges on tables not in that list will still be printed.

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