How to set a comment for a user: the purpose of user X is ...
To help reduce research during user cleanups, I'd like a simple way to store a comment in Oracle about a particular database user/schema--to have a simple way of identifying what project milestone the user supports. For example, something like:
comment on user X is 'supports verification of PTF #500 in environment ABC';
It would then be trivial to run a list of users, creation date and comments. Today we rely on non-standard side lists/tables (outside the Oracle dictionaries) to track this info.
Thanks for any ideas.
scot.balfour@com.lmco