Re: Help with TRUNCATE command

From: <eric_siglin_at_seagram.com>
Date: Wed, 29 Apr 1998 07:50:06 -0600
Message-ID: <6i77mb$90d$1@nnrp1.dejanews.com>

An undocumented Oracle feature (or error in the manuals <g>) with the TRUNCATE command, the user must have the DROP ANY TABLE priviledge in order to do a tuncate.

Eric Siglin
Tropicana Products, Inc.

In article <354571C2.2D50BF36_at_csu.edu.au>, 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 ?

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Apr 29 1998 - 08:50:06 CDT