Re: truncate table priviledge

Clarence wrote:
>
> Does anyone know if it's possible to grant another DB user the
> priviledge to truncate a table owned by my userID.
>
> I have granted SELECT, DELETE and UPDATE, but the other user cannot
> truncate the table.
>
> Clarence

I can't remember exactly which one but its a massive privilege (something like delete any table or drop any table).

Probably safer to create a PL/SQL program to do the truncate in the owning schema, and grant execute on that

hth

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."