Re: Help with TRUNCATE command

From: Michael S. Abbey <masint_at_istar.ca>
Date: Wed, 29 Apr 1998 02:54:43 GMT
Message-ID: <35469689.167957289@news.istar.ca>

On Tue, 28 Apr 1998 16:05:54 +1000, Steve Vella <svella_at_csu.edu.au> wrote:

>When using the TRUNCATE command on a 7.2.3.0.0 database I get the
>following error.
>SQL> truncate table concept.pegltran_work;
>truncate table schema.table_name

                      *

>ERROR at line 1:
>ORA-01031: insufficient privileges
>The DBA's have granted "DELETE ANY TABLE" access to the user account but
>it is not working. The database is not in the Trusted Oracle 7 in DBMS
>MAC mode. Can anyone who has come across this before please let me know
>how to fix this ?

I believe you have to be given the TRUNCATE ANY TABLE privilege.

Michael

+------------------------------------
+  Michael S. Abbey    Ottawa Canada
+  Co-author of Oracle8: A Beginner's Guide

+ and 5 other works in the Oracle Press Series

+------------------------------------

Received on Tue Apr 28 1998 - 21:54:43 CDT