Application Development Software

Hi,

Does anyone know how to join the IFSSYS.ODMV_ACCESSCONTROLENTRY view to some other table to get the actual permission names (All, Read, Modify, Protected, Delete) for one of those Access Control Entry rows ?

I'm trying to generate a simple listing of all the ACL's in the system, and it would be much easier for me to use a SQL script than the java API, although I realize the java API is documented and the tables/views are not (except for those few, which don't contain ACE information).

This is what I have so far:

select distinct
acl.name AS "ACL",
nvl(grp.name,usr.name) AS "ACL Member",
decode(grp.name,null,'User','Group') AS "Member Type",
ace.permissionbundles AS "Permissions?"
from ifssys.odmv_accesscontrolentry ace,
ifssys.odmbs_accesscontrollist acl,
ifssys.ifs_groups grp,
ifssys.ifs_users usr
where ace.acl = acl.acl
and ace.grantee = grp.group_id(+)
and ace.grantee = usr.user_id(+)
order by acl.name, nvl(grp.name,usr.name);

But I don't know how to get the NAMEs of the permission bundles. Anyone know?

Thanks,
David Frankel