Return-Path: Delivered-To: apmail-jackrabbit-users-archive@locus.apache.org Received: (qmail 52524 invoked from network); 21 Aug 2008 15:48:22 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 21 Aug 2008 15:48:22 -0000 Received: (qmail 98297 invoked by uid 500); 21 Aug 2008 15:48:18 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 98282 invoked by uid 500); 21 Aug 2008 15:48:18 -0000 Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@jackrabbit.apache.org Delivered-To: mailing list users@jackrabbit.apache.org Received: (qmail 98271 invoked by uid 99); 21 Aug 2008 15:48:18 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 21 Aug 2008 08:48:18 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of michael.e.harris@gmail.com designates 74.125.44.29 as permitted sender) Received: from [74.125.44.29] (HELO yx-out-2324.google.com) (74.125.44.29) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 21 Aug 2008 15:47:22 +0000 Received: by yx-out-2324.google.com with SMTP id 8so24388yxm.1 for ; Thu, 21 Aug 2008 08:47:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type; bh=1S4XnZn5DPnl8Ka8lWBtXIFvywj8DL8Nb3Zu8s1CrA4=; b=ucK6TnP6ym57ER58vx2vrWrZk0UfaqrAWu3RrNUK8zGGGgzP6OnALB5EzFpcBV3alT Gwzs5Zu+2L3SdfisX4lV4AtdsGYrIBHKDK6XiGxK9HeeY1i7+qMnaPN7JJC/zsG9Z5K0 CTDn4hzF7w7cvJnAhABT23Cc3RsVHNDaEn71I= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=PeKfJEzFOIe2dnuS1h8n78RHIKKkQHuSSvpcaDCu7DYiyLCUzSEF1xJ58HV0vsXhWc DJUSVfyl3d7I8jrt8ZVxc8GVNUAJaNV6FpS4EqPLPFWq1UBJsGFuP+XTIMdA9M9+3o9E ZsEpjRbQHOUOZUJdcZKg3UgDxDRz45Uuk2HEA= Received: by 10.103.207.18 with SMTP id j18mr1050407muq.21.1219333669348; Thu, 21 Aug 2008 08:47:49 -0700 (PDT) Received: by 10.103.223.16 with HTTP; Thu, 21 Aug 2008 08:47:49 -0700 (PDT) Message-ID: <82670ba40808210847r9221ccwf9fc8da2beed77fb@mail.gmail.com> Date: Thu, 21 Aug 2008 11:47:49 -0400 From: "Michael Harris" To: users@jackrabbit.apache.org Subject: database user priveleges MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_51554_82809.1219333669325" X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_51554_82809.1219333669325 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I had thought from previous questions that once the schema exists an OraclePersistenceManager could run as a non-root database user. When I try to use the application level database user I am getting insufficient privileges exceptions. I have stepped through the code and see that it thinks the schema does not exist. However, I can use a db browsing tool and see both the schema and tables that previous runs as db root user left behind. so let me reask -- should a non-root db user be able to do CRUD operations on the data in the repository with an OraclePesistenceManager? -- --------------------- Michael Harris ------=_Part_51554_82809.1219333669325--