IBM Infosphere Information Server (IIS)
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
