IFS Schema and its tables
394837Jun 26 2003 — edited Jul 1 2003Hi,
it seems that my IFS admin created a separated oracle database user for me to use with my java application (running on weblogic and using IFS just to store documents). The funny part is that it does not looks like another domain,instead it's just another oracle user called cmsadm01. When I try to do a select count(*) from ODM_DOCUMENTS i get an insufficient permissions error. The question is this: do I have to have permissions to all of the ODM* tables for this cmsadm01 or are there a list of ODM tables that should be enough?
My gut feel is that I should have owner rights of all tables created for IFS, but I have no idea what my admin wants to do by creating another oraccle user instead of giving me the default one (ifssys).
Thanks.