How do you find a user account's original creation date in IFS — it's not available on either the FND_USER or ORACLE_ACCOUNT views, and FND_USER's OBJID/OBJVERSION columns only reflect the most recent change, not the original creation.

All FAQ questions / Security and access

Answer

Query sys.dba_users — this is Oracle's own database view (not an IFS-specific one), and it tracks each Oracle account's actual creation timestamp directly at the database level, which is what you need since IFS's own application-level views don't track this.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Security and access questions