This is a snippet of very useful information, which is buried in the IBM documentation. So, I thought I would bring it up a level for those of you who may be making decisions regarding Information server installations (IIS). The table below provides an excerpt of the IBM IIS repository databases placement and guidance. Please, keep in mind that which of these databases may be required for your installation may be a subset of these database depending upon your IIS product offering license. Metadata Repository Databases Repository or Database Description Default Database And Schema Active Infosphere Information Server Metadata Repository …
Tag
Showing: 1 - 2 of 2 RESULTS
data integration linux
Oracle – How to get a list of user permission grants
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 oracle help Center > Database Reference > ALL_TAB_PRIVS view http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_2099.htm