Oracle Error ORA-46341: ALL STATEMENTS option cannot be supplied with BY SESSION clause

Oracle Error Message

ORA-46341: ALL STATEMENTS option cannot be supplied with BY SESSION clause

Reason for the Error

An attempt was made to use ALL STATEMENTS audit option with BY SESSION clause. ALL STATEMENTS audit option can be configured with BY ACCESS only.

Solution

Specify BY ACCESS instead of BY SESSION.