Is there a SQL query to pull a list of active users along with their current IFS license usage/assignment?

All FAQ questions / Security and access

Answer

Query the FND_LICENSED_ROLE_USER view, qualified with your application owner schema — for example SELECT * FROM <APPOWNER>.FND_LICENSED_ROLE_USER; — this returns the license role/usage information per user directly from the database.

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