Oracle BAM - SQL to List Users and Roles
By M&S Consulting (Ashok) on Jan 21st, 2008
Filed Under Technical Tips // Tags: oracle bam, oracle sql
Filed Under Technical Tips // Tags: oracle bam, oracle sql
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:
- Oracle Forms - Remove List Element from List Item
This one is a little wily, so John suggested we post it. Removing a label/value from a dropdown should be...
- Oracle APEX Video Training Tutorials - Complete List
A few kind readers asked, so we have delivered. Below is a consolidated list of all of the APEX training...
