Home » Oracle BAM Users and Roles
Written by ashok.aggarwal on Monday, January 21st, 2008
Categories: Oracle Fusion Middleware»BAM | Oracle Fusion Middleware

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

I think they took Microsoft tables and just slapped them into Oracle (having to 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:

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

No Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a comment

You must be logged in to post a comment.