You can activate “Threatening Roar” in response to an attack, but the attack has already been declared so it will resolve normally. After that, your opponent cannot attack for the rest of the turn.
You cannot activate “Threatening Roar” during your own turn.