Re: Truncate not working

bwskiles_at_adpc.purdue.edu wrote:
>
> I'm stumped and need help rather quickly to get a monthly refresh going.
>
> There's a table, COMPLETE.PAYROLL, and a user, OPERATIONS, that needs to truncate
> the table. OPERATIONS has been granted the DELETE ANY TABLE system privilege
> by SYS, and also has insert, select, update, delete rights to the table.
>
> When OPERATIONS issues the "truncate table complete.payroll;" command, it gets the
> insufficient privileges error (ORA-01031). I also granted the COMPLETE user the
> DELETE ANY TABLE privilege with admin option, and had COMPLETE grant the DELETE
> ANY TABLE privilege to OPERATIONS. Same error.

Despite the documentation, your need DROP ANY TABLE to truncate others' tables.

I don't know if this is a bug in the doucmentation or a bug in the implementation!

Charles Jardine - U. of Cambridge Computing Service. Received on Wed Jun 05 1996 - 00:00:00 CEST