Re: Help with TRUNCATE command

From: Rachel Carmichael <rachel.carmichael_at_citicorp.com>
Date: Wed, 29 Apr 1998 08:49:36 -0400
Message-ID: <354721E0.8A3FE496@citicorp.com>

You need 'drop any table' privilege... delete doesn't work.

Rachel

Michael S. Abbey wrote:

> 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 Wed Apr 29 1998 - 07:49:36 CDT