From dev-return-4513-apmail-sqoop-dev-archive=sqoop.apache.org@sqoop.apache.org Wed Dec 5 21:03:58 2012 Return-Path: X-Original-To: apmail-sqoop-dev-archive@www.apache.org Delivered-To: apmail-sqoop-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id AEB41D88C for ; Wed, 5 Dec 2012 21:03:58 +0000 (UTC) Received: (qmail 57787 invoked by uid 500); 5 Dec 2012 21:03:58 -0000 Delivered-To: apmail-sqoop-dev-archive@sqoop.apache.org Received: (qmail 57759 invoked by uid 500); 5 Dec 2012 21:03:58 -0000 Mailing-List: contact dev-help@sqoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@sqoop.apache.org Delivered-To: mailing list dev@sqoop.apache.org Received: (qmail 57749 invoked by uid 99); 5 Dec 2012 21:03:58 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 Dec 2012 21:03:58 +0000 Date: Wed, 5 Dec 2012 21:03:58 +0000 (UTC) From: "Venkat Ranganathan (JIRA)" To: dev@sqoop.apache.org Message-ID: <572811637.64868.1354741438438.JavaMail.jiratomcat@arcas> Subject: [jira] [Created] (SQOOP-741) The OracleConnect getTables() implementation needs to restrict tables to current user MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 Venkat Ranganathan created SQOOP-741: ---------------------------------------- Summary: The OracleConnect getTables() implementation needs to restrict tables to current user Key: SQOOP-741 URL: https://issues.apache.org/jira/browse/SQOOP-741 Project: Sqoop Issue Type: Bug Affects Versions: 1.4.2 Environment: Oracle 11g Reporter: Venkat Ranganathan SQOOP has various managers specific to each Database. Each of these managers provide database specific queries to list databases, tables, table columns, etc. The Oracle implementation (org.apache.sqoop.manager.OracleManager) defines queries specific for Oracle. The query for list tables in this implementation provides a list of all the tables the user has access to. This is inconsistent with the other queries defined (for getting list of table columns, get primary key for table etc) which restrict the table being queried to be owned by the user. This inconsisent behavior has more issues. For example, when we do import-all-tables (subject to other restrictions of import-all-tables), it fails because the list tables query used by import all tables returns tables like DUAL (which is a dummy Oracle table that gets blessed into all user schemas for historical reasons and other tables). I can provide a patch for this if there is agreement that this behavior needs fixing (and it will make Oracle manager work like other database connectors at least in spirit) -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira