Database Administration (MOSC)

MOSC Banner

System Event

edited Jul 30, 2013 7:08AM in Database Administration (MOSC) 5 commentsAnswered
Dear Colleaque,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center