Skip to Main Content

Application Development Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IFS Schema and its tables

394837Jun 26 2003 — edited Jul 1 2003
Hi,
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 29 2003
Added on Jun 26 2003
6 comments
1,627 views