Oracle BAM – SQL to List Users and Roles

Posted on Jan 21, 2008 in Technical Tips | 1 comment

I don’t really like what Oracle did with BAM user/roles and authentication.

I believe they took Microsoft (SQL Server) tables and just slapped them into Oracle (now requiring that we put quotes around tables and columns). I assume this process will change in the upcoming releases, but here is a quick SQL statement you can use to get a look at your users and their roles as BAM understands them:

1
2
3
4

SELECT iu."SysIterName" username, iur."RoleName" userrole
FROM orabam."SysIterUser" iu, orabam."SysIterRoleUserMapping" iur
WHERE iur."UserID" = iu."SysIterID"
ORDER BY iu."SysIterName"

Related Information:

1. Oracle Forms – Remove List Element from List Item

   This one is a little...

2. Oracle APEX Video Training Tutorials – Complete List

   A few kind readers asked,...

3. Strategy to Create a Usable Multi-function Task List (ADF)

   When People Interact with Executable...