Truncate table privilege on user 2 table to user1.

Hi All,

Application team wants to truncate privilege on user 2 table to user1.

we have 2 options for truncate privilege for user 2 table to user 1.

1) Grant "drop any table" to user1 - not recommended bcz that privilege is very powerful.

2) Create procedure for truncates tables owned by user2 and will give exec priv to user 1 - app team should to use commend like "exec <procedure_name>;" for truncate

but

they want to run commend like " truncate user2.<table_name>;".

so, how will do. please share the steps or process??