Examples - Field Level Security

The following are some worked examples of configuring Field Level Security:

Hide a Cross Tabulation Field

This example hides the field Customer Mail Indicator from the user vicuser1:

TEXT

> cat bank "Customer Mail Indicator" access vicuser1 read false

Unrestricted user:

vicuser1:

Hide a Summation Option

This example hides the summation option Customer Profit from the user user3:

TEXT

> cat bank "Customer Profit" access user3 read false

Unrestricted user:

user3:

Hide a Valueset

This example hides a value set from the group bankusers:

TEXT

> cat bank Area
[ XTAB Field : 'Area' ]
    [ ID : 'SXV4__Retail_Banking__F_Customer__Area_FLD' ]
    [ Value Set : 'SXV4__Retail_Banking__C_State' ]
        [ Value Set : 'SXV4__Retail_Banking__C_Geography_2' ]
            [ Value Set : 'SXV4__Retail_Banking__C_Geography_1' ]
                [ Value Set : 'SXV4__Retail_Banking__C_Geography_0' ]

> cat bank Area "SXV4__Retail_Banking__C_Geography_1" access bankusers read false

Unrestricted user:

User in the group bankusers:

Hide a Value within a Valueset

This example hides the values Unknown and Not Applicable from Marital Status for the user user3 (note that each individual value has to be explicitly specified):

TEXT

> cat bank "Marital Status" "Unknown" access user3 read false
> cat bank "Marital Status" "Not Applicable" access user3 read false

Unrestricted user:

user3:

This example hides all values under Area except Victoria from vicuser1:

TEXT

> cat bank "Area" SXV4__Retail_Banking__C_State" "Victoria" access vicuser1 read true
> cat bank "Area" SXV4__Retail_Banking__C_State" "New South Wales" access vicuser1 read false
> cat bank "Area" SXV4__Retail_Banking__C_State" "Queensland" access vicuser1 read false
> cat bank "Area" SXV4__Retail_Banking__C_State" "South Australia" access vicuser1 read false
> cat bank "Area" SXV4__Retail_Banking__C_State" "Western Australia" access vicuser1 read false
> cat bank "Area" SXV4__Retail_Banking__C_State" "Tasmania" access vicuser1 read false
> cat bank "Area" SXV4__Retail_Banking__C_State" "Northern Territory" access vicuser1 read false
> cat bank "Area" SXV4__Retail_Banking__C_State" "Australian Capital Territory" access vicuser1 read false
> cat bank "Area" SXV4__Retail_Banking__C_State" "Unknown" access vicuser1 read false
> cat bank "Area" SXV4__Retail_Banking__C_State" "Null" access vicuser1 read false

Unrestricted user:

vicuser1: