E8.12 Column Security with *ALL in Data Item

[Rauf]

Is there any way to hide all columns of an application by Column Security except few columns only ? I was expecting that *ALL in the Data Item field but it gives error.
My intention is to prepare an inquiry screen, for example, a Address Master Info screen. The UserA should only see the Address Number and Alpha Name but UserB can see all the provided columns.

So the Security Workbench - Columns Security for UserA will be as follows

Table	Data Item	View	Add	Change
*ALL	*ALL ( but giving error as attached)	N	N	N
*ALL	AN8	Y	N	N
*ALL	ALPH	Y	N	N

 

[MFreitag]

*ALL is not a Data Item, hence it will never work. So in your case (and on your Tools Release specifically) you might need to go ahead and put in N records for all the other columns, which is probably not a good idea to do that on *ALL level. Not sure about forcing grid layouts on users in 8.96

 

[Rauf]

Thank you MFreitag,

I will put N columns within app level.