From oracle-l-bounce@freelists.org Fri Dec 3 13:57:43 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iB3JvhF12502 for ; Fri, 3 Dec 2004 13:57:43 -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 iB3Jvhd12497 for ; Fri, 3 Dec 2004 13:57:43 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7E97772C3B9; Fri, 3 Dec 2004 15:04:06 -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 18685-63; Fri, 3 Dec 2004 15:04:06 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1110C72CF21; Fri, 3 Dec 2004 15:02:50 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit Subject: RE: Truncate another users table Date: Fri, 3 Dec 2004 15:00:10 -0500 Message-ID: <4001DEAF7DF9BD498B58B45051FBEA6501DFA963@25exch1.vicorpower.vicr.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Truncate another users table Thread-Index: AcTZcOL16wfebfuKQBqforQWJYHQxAAAb7SA From: "Goulet, Dick" To: , X-OriginalArrivalTime: 03 Dec 2004 20:00:10.0395 (UTC) FILETIME=[B1B206B0:01C4D972] X-archive-position: 13102 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: DGoulet@vicr.com Precedence: normal Reply-To: DGoulet@vicr.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Nothing. Truncate is a DDL command, not DML. As such synonyms don't count.=20 Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- From: Larry Hahn [mailto:lhahn_60@yahoo.com]=20 Sent: Friday, December 03, 2004 2:43 PM To: Oracle-L@freelists.org Subject: Truncate another users table 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.=20 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.=20 Thanks in advance for any help. Larry Hahn =09 __________________________________=20 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 -- http://www.freelists.org/webpage/oracle-l