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’
[…] Oracle – How to get a list of user permission grants […]