SQL & PL/SQL

Hi,
I've 2 schemas IS_OWNER and IS_USER in the same database.

IS_OWNER contains a table named TAB_BASE. IS_USER have synonym for the same table and have select, insert, update and delete privileges on the table

I want to truncate the table TAB_BASE in schema IS_USER, but system gives the insufficient privileges error.

While referring previous OTN threads, I found that truncate from another user is possible when IS_USER will be having drop any table privilege(which is obviously not a desirable privilege to give as IS_USER should have minimal privileges)

I also came to know about below method to do so:
Create a stored procedure and use Dynamic SQL to truncate the required tables and pass the execute permission to IS_USER. But again we require a privilege to truncate the table directly without using a SP.

Is there any other way to achieve this goal?

Thanks
Deepak