System Event
I stumble to the Code below, about a week ago:
SELECT ora_sysevent, ora_dict_obj_owner, ora_dict_obj_name, ora_dict_obj_type, sql_text (1), USER, SYSDATE FROM DUAL;
This code if know how to use it, give me room to capture most of my activities on the database, but I saw a grave disadvantage of the code I can capture user password in a plain language;
example, if I give instruction as follows, it will be capture like that for me:
SQL>ALTER USER abc IDENTIFIED BY qaz123;
This script above will capture it as it is.