From oracle-l-bounce@freelists.org Fri Dec 3 13:40:47 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iB3Jel710715 for ; Fri, 3 Dec 2004 13:40:47 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id iB3Jeld10710 for ; Fri, 3 Dec 2004 13:40:47 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A6B9172C420; Fri, 3 Dec 2004 14:47:10 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14860-41; Fri, 3 Dec 2004 14:47:10 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7208C72C334; Fri, 3 Dec 2004 14:45:53 -0500 (EST) Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=J2ebfTxzuFabQPugoIiajbdrMwgdWzuOF3b5Z8BDLTKZ4IPyG8xSV9kFFcBRbxN4niLb53m2O05DG1cZvKliZaxO7Go4+UXMJ4nYRkWmTyjCaRr0lpfj6uzBYjHQOF7mKhApY9wiszWD1vABNR3AG9YAvkcCWqau3QbucID95cc= ; Message-ID: <20041203194314.82767.qmail@web42002.mail.yahoo.com> Date: Fri, 3 Dec 2004 11:43:14 -0800 (PST) From: Larry Hahn Subject: Truncate another users table To: Oracle-L@freelists.org MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-archive-position: 13097 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: lhahn_60@yahoo.com Precedence: normal Reply-To: lhahn_60@yahoo.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org List, I am running version 8.1.7 on Sun. I am trying to allow a user (A) to truncate another users (B) table. I have already given the DROP ANY TABLE right to A, and made a public synonym for the table owned by B. I can't do the truncate if I just give the table name, but if I put the owner first (truncate table A.) it works. What have I missed? Because the truncate command that I ultimately need to run is buried in the vendors code, I am not able to create and execute the stored procedure that I have seen suggested here on the list in the past. Thanks in advance for any help. Larry Hahn __________________________________ Do you Yahoo!? Send holiday email and support a worthy cause. Do good. http://celebrity.mail.yahoo.com -- http://www.freelists.org/webpage/oracle-l