I have two interfaces in the same project and same work repository.
I want to create a security access as follows :
User A can view only Interface A and not Interface B.
Similarly, User B can view only Interface B and not interface A.
Can this be achieved? I was looking at the ODI document, am not sure if this could be done.
Any inputs would be appreciated
Try the following thing :
On the Security module, you must create profils with non-generic privileges. Non Generic privileges allow you to set security on ODI objects (= instances).
There are some prebuilt non-generic profils. Example : "NG Designer" ; "NG Metadata"
The easiest way to do that is to change the position of the security tab. I usually set it on right of the ODI Studio window (While keeping Designer, Topology and Executor on the left side).
Then on the designer tab, you can just expand your project, and drag your interface onto one user in the security tab. If you then expand this user, you can see the interface. If you double click on it, you can choose what the user can/cannot do on this interface (View only ? View/Edit ? ...).
If I remember, you can also click on the "privileges" tab of your object in DESIGNER.
In this tab, you can see all the users/groups with their privileges, and you can change privileges.
Of course, you have to do that with an administrator user.
You have to create new profiles first, that are non-generic.(For example, non-generic metadata designer etc). Then, drag these profiles to the user(s) you have created. Then, you can drag the respective interfaces to the user profiles. This is not explained very well in the ODI Oracle documentation.
Hope this helps:
Edited by: 937685 on Dec 4, 2012 8:09 AM
I'm trying the following approaches discussed.
I've a few observations.
Below are the steps am trying.
1.i create two users
2. Assign the CONNECT profiles and uncheck the 'generic privilege' check box for the object 'View'under Object.
3. Assign NG_DESIGNER profile and drag drop the interfaces check the View and Execute check boxes.
When i log into as the newly created user, I do not see any projects at all!!
I did something on trail and error and was able to see the interface but it gave access denied error when i tried executing it.
Am I missing anything obvious??