Disable the access to certain tables in one repository

[Former Member]

To all experts,

I have one repository which contains multiple main tables and a few other sub tables, how can I limit the access for users to only access their specified tables?

CUSTOMER and VENDOR are create as two main tables in one repository, since they share most of the sub tables,that's why create together. now, I want user A log on the Data Manager and only sees the CUSTOMER table and no other else. how can I make that happen? from the role, I can limit their usage authorization but not the tables entirely. can anyone help me?

[former_member204080 · Accepted solution]

Hi,

In the role just give him display access

[Former Member · Accepted solution]

I knew this function, what I wanted to do is: user not even able to see that table from the table dropdown pane in the data manager. I don't want certain user to see that table at all, not just to limit their read/write function. thanks

[Former Member]

Hi Austen,

In Console, under Roles node, there is a tab called Tables and Fields.

It has one column called Constraints. This could come in handy to achieve your requirement. You need to do following:

Create separate roles for Customer and Vendor users.

Create one dummy account group say "Dummy" in account groups look up table for Vendors.

And this account group will not be used by any vendor record.

So in customer role, you can add this account group in the Constraints field which will allow the user to see only the records containing Dummy account group. And since there will be no such record, so user will not see any vendor record.

and vice-versa can be done for vendor role.

Note : You have to make sure that account group tables for vendor and customer are separate.

I hope this helps you. Kindly get back with your findings.

[Former Member]

Thank you all for helping me on this topic,

I was originally used this method, it looks wierd, but works, i guess this is the only workarround solution for this issue since the client didn't require EP.

[Former Member]

Hi Austen,

You can explore the option of master and slave repository or MASK . I think these options can fulfil your requirement.

Thanks,

Sima

[Former Member]

Hi Austen,

Just to add here. Instead of Mask, Named Search is better option as it will get updated automatically everytime new records are created.

While for Mask, you will need to manually add the newly created records each time. And also it will be difficult to track the records newly created and adding them to Mask. For Named search option, you can proceed as suggested by Prasad.

If your query has been solved, then please mark this thread as Answered.

Thank you.

Message was edited by: Ankush Bhardwaj

[Former Member]

Hello Raghu,

If you want to limit the access of the Vendor Main table to the Customer team you can achieve this by following the below process

1. Login as administrator.

2. Select the Main table as Vendor.

3. Create a Named search with the expression IF(IS_NOT_NULL(Vendor Number),False,True)

4. Assign this Named search to the Customer team's Role (In the Constraint column)

5. Give the read only access to the Vendor Main table for the Customer team's Role.

Since the Vendor Number is a Mandatory field, though you can see the Vendor Main table in the drop down in data manager, you will not see any vendor data (since we have written an expression) and you cannot create any Vendor(since we have given the Read only access to the Customer team;s Role)

Hope this helps.

Rgds,

Prasad.

[Former Member]

Hi Prasad,

The above question asked by Austen.

Hi Asten ,

Prasad given explanation regarding your question.

If you want to limit the access of the Vendor Main table to the Customer team you can achieve this by following the below process

1. Login as administrator.

2. Select the Main table as Vendor.

3. Create a Named search with the expression IF(IS_NOT_NULL(Vendor Number),False,True)

4. Assign this Named search to the Customer team's Role (In the Constraint column)

5. Give the read only access to the Vendor Main table for the Customer team's Role.

Since the Vendor Number is a Mandatory field, though you can see the Vendor Main table in the drop down in data manager, you will not see any vendor data (since we have written an expression) and you cannot create any Vendor(since we have given the Read only access to the Customer team;s Role)

Hope this helps.

Rgds,

Prasad.

Thanks,

Raghu

[Former Member]

Hi,

Sorry, i should have addressed to Austin

Rgds,

Prasad

[Former Member]

Hi Austen,

You can hide the table from the drop down list pane in Data Manager by setting the 'Hide table' property to 'Yes' in Table Detail pane in SAP MDM Console. First you have to unload the repository and then make the changes. But you can set the property only once when you create the table in the console. Hope this may help..

[Former Member]

Rimpy,

As per your solution, if we hide a table with "Hide Table" property in Console, it will not be visible to any user in Data Manager. It will be permanent hide. To un-hide the same table, we will have to again login into Console, Stop repository and change the "Hide Table" property from Yes to No.

Austen's requirement is: A desired table should not be visible to a particular user in Data Manager.

Hope, I cleared your understanding on the requirement..!!

Thx/ -Tarun

[Former Member]

Yes Tarun, U are right.

[Former Member]

Austen,

We cannot restrict any user to view tables from the Drop Down Table List Pane, as SAP MDM does not support with such functionalists.

As a workaround, if you have Portal implemented in your solution, you can design the customize screens, in which you can restrict a user to a particular table or as you want.

Thx/ -Tarun