Truncate table from stored procedure
If user A tries to truncate a table owned by user B, oracle throws the error "ORA-01031: insufficient privileges". this truncate happens inside a stored procedure and the stored proc is owned by user A.
but note that, user A can successfully truncate the table using an explicit truncate command outside stored procedure.
does anyone know why am i getting this error message when i try to truncate inside the stored procedure.
thanks