You execute the following command toauditdatabase activities: SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; What is the effect of this command()
- AOneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.
- BOneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.
- COne audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.
- DOne audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
- EOne audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.