Agile (MOSC)

MOSC Banner

What database table includes user role information?

edited Aug 15, 2016 5:00AM in Agile (MOSC) 1 commentAnswered ✓

I'd like to search for users that have, and do not have, specific roles assigned to their accounts via SQL. I can query user accounts via AGILEUSER table, but cannot identify how to incorporate ROLES into the SQL. I'm assuming this is an alternate table, which I've searched for but cannot find.  What table should I include/query?

Note: I am fully aware of the admin reports that include this information; I'd just rather query via SQL.

Thanks in advance for any help.

Regards,
Drew

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