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 Value Set

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 Value Set

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:

Hide all Values Except One

In earlier versions of SuperSTAR, if you wanted to hide all the values in a value set except one, you had to explicitly deny access to each value individually. For example, the following commands hide 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

There is now a quicker way to accomplish this: you no longer need to explicitly deny access to each value individually. Instead, you can deny access to all values in a value set with a single command, and then enable only the relevant ones. The following commands achieve the same result as the previous set of commands:

CODE

> cat bank "Area" SXV4__Retail_Banking__C_State values access vicuser1 read false
> cat bank "Area" SXV4__Retail_Banking__C_State "Victoria" access vicuser1 read true

Unrestricted user:

vicuser1: