I found this more practical:

select sys.objects.name as 'table',
sys.indexes.name as 'index',
status = case is_disabled
when '1' then 'disabled'
when '0' then 'enabled'
end
from...

Unfortunately, Session_context() didn't work as I hoped to.
I used it in a procedure, which worked OK.
But when I use the procedure in a view, the behavior is according to...

Thanks.
I think that'll do the trick.

The DWH is a datamart, only showing data from the source systems.
My procedure is something like
If < the user has access to this column >
    show < real data >
else
  ...