select banner from v$version where rownum = 1;
Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
audit all by act_dev by access;
audit select table, update table, insert table, delete table by act_dev by access;
audit execute procedure by act_dev by access;
CREATE TABLE test_audit1 (
c1 INT
);
INSERT INTO test_audit1 VALUES ( 1 );
COMMIT;
SELECT
*
FROM
test_audit1;
select username,
extended_timestamp,
owner,
obj_name,
action_name
from dba_audit_trail;
Below output shows nothing in the dba_audit_trail.
SYSTEM 09-NOV-16 08.45.19.888019000 PM ASIA/CALCUTTA PUBLIC PRODUCT_PROFILE DROP PUBLIC SYNONYM
SYSTEM 09-NOV-16 08.45.19.907211000 PM ASIA/CALCUTTA PUBLIC PRODUCT_USER_PROFILE DROP PUBLIC SYNONYM
SYSTEM 09-NOV-16 08.45.19.750495000 PM ASIA/CALCUTTA LOGON
CTXSYS 09-NOV-16 08.45.46.066837000 PM ASIA/CALCUTTA LOGON
SYSTEM 09-NOV-16 08.45.19.897967000 PM ASIA/CALCUTTA PUBLIC PRODUCT_PROFILE CREATE PUBLIC SYNONYM
SYSTEM 09-NOV-16 08.45.19.912750000 PM ASIA/CALCUTTA PUBLIC PRODUCT_USER_PROFILE CREATE PUBLIC SYNONYM
ORACLE_OCM 09-NOV-16 08.45.19.520220000 PM ASIA/CALCUTTA LOGOFF
SYSTEM 09-NOV-16 08.45.19.915432000 PM ASIA/CALCUTTA LOGOFF
CTXSYS 09-NOV-16 08.45.46.383068000 PM ASIA/CALCUTTA LOGOFF
November 14, 2019 - 10:24 pm UTC
That is something you'll need to take up with RDS....
SQL> conn system/admin
Connected.
SQL>
SQL> drop user act_dev cascade;
User dropped.
SQL>
SQL> create user act_dev identified by act_dev;
User created.
SQL> grant connect, resource to act_Dev;
Grant succeeded.
SQL> alter user act_Dev quota 200m on users;
User altered.
SQL>
SQL> audit all by act_dev by access;
Audit succeeded.
SQL> audit select table, update table, insert table, delete table by act_dev by access;
Audit succeeded.
SQL> audit execute procedure by act_dev by access;
Audit succeeded.
SQL>
SQL> conn act_dev/act_dev
Connected.
SQL>
SQL> CREATE TABLE test_audit1 (
2 c1 INT
3 );
Table created.
SQL>
SQL> INSERT INTO test_audit1 VALUES ( 1 );
1 row created.
SQL>
SQL> COMMIT;
Commit complete.
SQL>
SQL> SELECT
2 *
3 FROM
4 test_audit1;
C1
----------
1
1 row selected.
SQL>
SQL> conn system/admin
Connected.
SQL>
SQL> select username,
2 extended_timestamp,
3 owner,
4 obj_name,
5 action_name
6 from dba_audit_trail
7 where username = 'ACT_DEV'
8 @pr
==============================
USERNAME : ACT_DEV
EXTENDED_TIMESTAMP : 15-NOV-19 06.23.19.421000 AM +08:00
OWNER : ACT_DEV
OBJ_NAME : TEST_AUDIT1
ACTION_NAME : CREATE TABLE
==============================
USERNAME : ACT_DEV
EXTENDED_TIMESTAMP : 15-NOV-19 06.23.19.343000 AM +08:00
OWNER :
OBJ_NAME :
ACTION_NAME : LOGON
==============================
USERNAME : ACT_DEV
EXTENDED_TIMESTAMP : 15-NOV-19 06.23.19.436000 AM +08:00
OWNER : ACT_DEV
OBJ_NAME : TEST_AUDIT1
ACTION_NAME : INSERT
==============================
USERNAME : ACT_DEV
EXTENDED_TIMESTAMP : 15-NOV-19 06.23.19.343000 AM +08:00
OWNER : SYSTEM
OBJ_NAME : SQLPLUS_PRODUCT_PROFILE
ACTION_NAME : SELECT
==============================
USERNAME : ACT_DEV
EXTENDED_TIMESTAMP : 15-NOV-19 06.23.19.343000 AM +08:00
OWNER : SYSTEM
OBJ_NAME : PRODUCT_PRIVS
ACTION_NAME : SELECT
==============================
USERNAME : ACT_DEV
EXTENDED_TIMESTAMP : 15-NOV-19 06.23.19.343000 AM +08:00
OWNER : SYSTEM
OBJ_NAME : SQLPLUS_PRODUCT_PROFILE
ACTION_NAME : SELECT
==============================
USERNAME : ACT_DEV
EXTENDED_TIMESTAMP : 15-NOV-19 06.23.19.343000 AM +08:00
OWNER : SYSTEM
OBJ_NAME : PRODUCT_PRIVS
ACTION_NAME : SELECT
==============================
USERNAME : ACT_DEV
EXTENDED_TIMESTAMP : 15-NOV-19 06.23.19.358000 AM +08:00
OWNER : SYS
OBJ_NAME : DUAL
ACTION_NAME : SELECT
==============================
USERNAME : ACT_DEV
EXTENDED_TIMESTAMP : 15-NOV-19 06.23.19.358000 AM +08:00
OWNER : SYS
OBJ_NAME : X$KSUXSINST
ACTION_NAME : SELECT
==============================
USERNAME : ACT_DEV
EXTENDED_TIMESTAMP : 15-NOV-19 06.23.19.358000 AM +08:00
OWNER : SYS
OBJ_NAME : X$KVIT
ACTION_NAME : SELECT
==============================
USERNAME : ACT_DEV
EXTENDED_TIMESTAMP : 15-NOV-19 06.23.19.358000 AM +08:00
OWNER : SYS
OBJ_NAME : X$QUIESCE
ACTION_NAME : SELECT
==============================
USERNAME : ACT_DEV
EXTENDED_TIMESTAMP : 15-NOV-19 06.23.19.358000 AM +08:00
OWNER : SYS
OBJ_NAME : X$KJIDT
ACTION_NAME : SELECT
==============================
USERNAME : ACT_DEV
EXTENDED_TIMESTAMP : 15-NOV-19 06.23.19.358000 AM +08:00
OWNER : SYS
OBJ_NAME : GV$INSTANCE
ACTION_NAME : SELECT
==============================
USERNAME : ACT_DEV
EXTENDED_TIMESTAMP : 15-NOV-19 06.23.19.358000 AM +08:00
OWNER : SYS
OBJ_NAME : V$INSTANCE
ACTION_NAME : SELECT
==============================
USERNAME : ACT_DEV
EXTENDED_TIMESTAMP : 15-NOV-19 06.23.19.358000 AM +08:00
OWNER : SYS
OBJ_NAME : V_$INSTANCE
ACTION_NAME : SELECT
==============================
USERNAME : ACT_DEV
EXTENDED_TIMESTAMP : 15-NOV-19 06.23.19.483000 AM +08:00
OWNER : ACT_DEV
OBJ_NAME : TEST_AUDIT1
ACTION_NAME : SELECT
==============================
USERNAME : ACT_DEV
EXTENDED_TIMESTAMP : 15-NOV-19 06.23.19.343000 AM +08:00
OWNER : SYS
OBJ_NAME : DUAL
ACTION_NAME : SELECT
==============================
USERNAME : ACT_DEV
EXTENDED_TIMESTAMP : 15-NOV-19 06.23.19.358000 AM +08:00
OWNER : SYS
OBJ_NAME : DBMS_APPLICATION_INFO
ACTION_NAME : EXECUTE PROCEDURE
==============================
USERNAME : ACT_DEV
EXTENDED_TIMESTAMP : 15-NOV-19 06.23.19.421000 AM +08:00
OWNER : SYS
OBJ_NAME : DBMS_STANDARD
ACTION_NAME : EXECUTE PROCEDURE
==============================
USERNAME : ACT_DEV
EXTENDED_TIMESTAMP : 15-NOV-19 06.23.19.499000 AM +08:00
OWNER :
OBJ_NAME :
ACTION_NAME : LOGOFF
PL/SQL procedure successfully completed.
SQL>