Connected to Oracle Database 11g Release 11.2.0.1.0 
Connected as system@//192.168.1.201/DBOFFICE

SQL> AUDIT SELECT TABLE, UPDATE TABLE, INSERT TABLE, DELETE TABLE BY dmaslov BY ACCESS;

Audit succeeded


SQL> AUDIT EXECUTE PROCEDURE BY dmaslov BY ACCESS;

Audit succeeded


SQL> select * from dba_stmt_audit_opts where user_name is not null;

USER_NAME                      PROXY_NAME                     AUDIT_OPTION                             SUCCESS    FAILURE
------------------------------ ------------------------------ ---------------------------------------- ---------- ----------
DMASLOV                                                       EXECUTE PROCEDURE                        BY ACCESS  BY ACCESS
DMASLOV                                                       DELETE TABLE                             BY ACCESS  BY ACCESS
DMASLOV                                                       UPDATE TABLE                             BY ACCESS  BY ACCESS
DMASLOV                                                       INSERT TABLE                             BY ACCESS  BY ACCESS
DMASLOV                                                       SELECT TABLE                             BY ACCESS  BY ACCESS

SQL> NOAUDIT SELECT TABLE, UPDATE TABLE, INSERT TABLE, DELETE TABLE BY dmaslov;

Noaudit succeeded


SQL> NOAUDIT EXECUTE PROCEDURE BY dmaslov;

Noaudit succeeded


SQL> select * from dba_stmt_audit_opts where user_name is not null;

USER_NAME                      PROXY_NAME                     AUDIT_OPTION                             SUCCESS    FAILURE
------------------------------ ------------------------------ ---------------------------------------- ---------- ----------

SQL>