Since the Infosphere, information server, repository, has to be installed manually with the scripts provided in the IBM software, sometimes you run into difficulties. So, here’s a quick script, which I have found useful in the past to identify user permissions for the IAUSER on Oracle database’s to help rundown discrepancies in user permissions.
SELECT *
FROM ALL_TAB_PRIVS
WHERE GRANTEE = ‘iauser’
If we cannot run against the ALL_TAB_PRIVS view, then we can try the ALL_TAB_PRIVS view:
SELECT *
FROM USER_TAB_PRIVS
WHERE GRANTEE = ‘iauser’
Related References
- Infosphere Information Server (IIS) – Metadata Repository Databases
- Infosphere DataStage – Designer Client Repository Structure
- What are the Core Capability of Infosphere Information Server?
- InfoSphere Information Server Suites
- What is IMAM?
- What are the Tiers of InfoSphere Information Server (IIS)?
- InfoSphere Information Server (IIS) Component Descriptions
- Infosphere Datastage – How to Generate Datastage Technical Design Job Reports