How Do I Check the Current Field Level Security Settings?
The following examples show how you can check the current Field Level Security settings configured on the dataset.
Check If Field Level Security Is In Use
To find out if a dataset has any Field Level Security configured, use the command:
The security flag at the dataset level is set to true if there is any Field Level Security set anywhere on the dataset. Otherwise the flag is set to false.
In this example, the Retail Banking dataset has Field Level Security configured, but the people dataset does not:
Check Field Level Security for a Specific Field
To check the security settings for a field, summation option, value or value set use the command:
In this example, access to Marital Status is explicitly denied to nswuser1, qlduser1 and Guests; access is explicitly granted to vicuser1:
In this example there are no explicit permissions set to the Marital Status value Single:
Check Field Level Security for a Specific Field and User/Group
To check the security settings applicable to a specific user or group for a given field, summation option, value or value set, use this command:
In this example the bankusers group has explicit access to the Marital Status field:
How Do I Reset Field Level Security?
Use these commands to reset Field Level Security. The permissions will be reset to those in place at the time SuperSERVER was last started.
Reset Security for a Field/Summation Option/Value/Value Set
To reset the security for a given field, summation option, value or value set, use this command:
This example resets all permissions on the field Marital Status:
Reset Security for a Specified User/Group
To reset the security for a specific user or group, use this command:
This example resets permissions on the field Marital Status for the bankusers group: