Re: Truncate Command

Hi,

you must grant the user drop any table, Oracle don't has the privilege truncate any table.

You can check the dba_sys_priv as user internal or system to see which dba role has which privilege.

RO

Lui Yuan Tze wrote:

> Hi,
> What privileges is reqd for an oracle user to Truncate a table belonging
> to another schema ?
> I tried to grant Delete Table to the oracle user but still get insufficient
> privileges .
>
> Cheers
Received on Wed Apr 15 1998 - 11:13:20 CDT