Hide a sensitive Data of a standard Database table

[mayank_agarwal7]

Hi,

I have a standard Table. This standard table has "Display Maintenance Allowed".

This table generally has some sensitive data which shouldn't be visible to anyone except the Administrators.

What settings should I do so that the Data is visible to only administrators and not to any other users?

Thanks & Regards,

Mayank Agarwal

[g_srivastava]

Hi Mayank,

You can use the activity code only administrtaor has acitvity code active for him that is write display update delete etc etc.For rest of the user block this activity code Dont give them even display authority.I hope you rememebr authority check.Please check into it TSTCA is the table used.Hope you will get some insight in the appraoch to resolve your query.Look into tcode SU20 and SU21.

Have a best day ahead.

[mayank_agarwal7]

Hi Srivastava,

Thanks for the reply.

I agree with you solution. I think by Activity you mean "Authorization group"....right?

this table already has a Standard SAP Authorization group assigned to it.

We cant change this authorization group because presently this authorization group is used by 519 more tables. If we change this authorization group then all other tables will be hampered.

Can you please let us know how the activity code can be assigned to table?

Thanks & regards,

Mayank agarwal

[g_srivastava]

Hi Mayank,

Please look at this wiki.Hope it will be a good insight of what i was telling about.Well for the occurance of the field yes we do have to update it every where in use.The best thing is we can check where used list for the field and see how many places it is being used hope it work well.

[filter|https://wiki.sdn.sap.com/wiki/display/PLM/Layout%20and%20Filter%20Functionality]

Have a best day ahead.

[mayank_agarwal7]

Hi Srivastava,

Thanks again for your reply.

I dont have to hide the field. I have to hide the entire table i.e all the field values of the table.

you mentioned something about Activity code. I dont think that there is a place to assign the activity code in the table. Instead there is something called as Authorization object & Authorization Group that is assigned on a table Level. Authorization group actually works like Activity and is hence linked to authorization object. Please correct me if I am wrong.

In my case there is a standard table which is already having an Authorization Object and Authorization group assigned to it. and this authorization group is assigned to many other tables as well. Hence I cant change the activity for the Authorization group. Because if I remove the Activity EDIT & DISPLAY from authorization group then it will be replicated for all other tables as well.

Is there any way in which we can make this table contents invisible for all users except administrators?

Thanks & Regards,

Mayank agarwal

[Former Member]

Hi,

I would suggest to create a different authorization object and group specifically for this table and attach it to your table.. This will help you to provide whatever authorization you want to give..