Re: Truncate Command

S Chavali wrote:

> 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
>
> You will also need to grant the DROP TABLE privilege.

I may be wrong but I think you may require "drop any table" privilege. Ofcourse now that I've written it, it does seem stange.

>
>
> --
>
> hope this helps !
> Srini
>
> (to reply, change "nospam" to "chavali" in my email address. :-) )

--

Bobby Abraham                   email : bobby_at_cm.co.za
Computer Management       Fax   : +27 31 3325552
Durban, South Africa           Phone : +27 31 3325541