Previous Topic Next Topic

Security Dialog

The Security dialog helps you to specify the security settings for a data source security entry. It appears when you right-click Security Entry in the Data Source > Security node in the Catalog Manager, select New Security Entry from the shortcut menu, input a name for the new security policy and then select OK.

The following are details about options in the dialog:

Users/Groups/Roles

Lists all the users, roles, groups for the security policy.

• 
  Adds a user/group/role. After you select the button, a drop-down menu will be shown:
  • Add User
    Creates a new user in the Add User dialog.
  • Add Group
    Creates a new group in the Add Group dialog.
  • Add Role
    Creates a new role in the Add Role dialog.
  • Import from Logi JReport Server
    Opens the Import from Logi JReport Server dialog to import users, roles, and groups from Logi JReport Server.
  • Import from File
    Imports users, roles, and groups from an xml file.
• 
  Exports the users, roles, and groups to an xml file.
• 
  Deletes the selected user/group/role.
• 
  Edits the selected user/role/group in the displayed dialog.
• Search box
  It allows you to search for the user/role/group in the list below. Type in the text and the principals containing the matched text will be shown.

Valid RLS

Specifies whether to use RLS policy for this security entry. If unchecked, the RLS policy will not be applied and all the records will be available to the users.

Valid CLS

Specifies whether to use CLS policy for this security entry. If unchecked, the CLS policy will not be applied and all the records will be available to the users.

Disable Policy Settings

• When it is unchecked, you are able to specify a security policy for the principal. However, if the record level security and column level security are left blank, the principal will not be able to view any data records, unless it inherits some permissions from another group or role.
• When it is checked, you are not allowed to specify record level security or column level security. The principal will have full access to all the data records in the reports which adopt this security policy entry.

Record Level Security tab

Specifies the condition statements.

• Expression
  Specifies the field on which the condition is based. You can type in the field directly or select the button next to the text box to select the desired field.
• Operator
  Specifies the operator to compose the condition expression.
  
  • =
    Equal to
  • >
    Greater than
  • <
    Less than
  • >=
    Greater than or equal to
  • <=
    Less than or equal to
  • <>
    Not equal to
  • in
    Causes an enumerated list of values to appear in the WHERE clause predicate, used for evaluating for a true condition. For the operator "in", multiple values separated by comma (,) are allowed.
• Value
  Specifies the value of how to build the condition. You can type in the value manually or select the button next to the value text box to specify the value.
• More
  Lists some additional commands.
  • AND
    Specifies the relationship between two expression statements as logical AND. If this line is the last line in the expression list, when you select AND or OR, and a new line will be appended to the end of the list as well.
  • OR
    Specifies the relationship between two expression statements as logical OR. If this line is the last line in the expression list, when you select AND or OR, and a new line will be appended to the end of the list as well.
  • Insert Row
    Inserts a new line after the current line.
  • Delete Row
    Deletes the current line.
  • New Group
    Adds a new expression group to the list. The relationships between two groups can be:
    
    • AND- Logical AND relationship between two groups. Records satisfying both condition groups will be retrieved.
    • OR- Logical OR relationship between two groups. Records satisfying either one of the condition groups will be retrieved.
    • AND NOT - Records which satisfy the first condition group but not the second will be retrieved.
    • OR NOT - Records which satisfy the first condition group, or which do not satisfy the second condition group will be retrieved.
      

Column Level Security tab

Lists all the available resources in the catalog. Select the required resources to allow or deny them to be revealed to the principal.

• Select Column
  Specifies the columns that are to be shown to (or hidden from) the principal.
• Allow all
  Allows all the columns in the field list to be revealed to the principal no matter whether the parent groups/roles allow them.
• Deny all
  Hides all the columns in the field list from the principal no matter whether the parent groups/roles allow them.
• Allow
  Allows the selected columns in the field list to be revealed to the principal no matter whether the parent groups/roles allow them. Whether the principal can see the unselected columns depends on whether the parent groups/roles allow them.
• Deny
  Hides the selected columns in the field list from the principal no matter whether the parent groups/roles allow them. Whether the principal can see the unselected columns depends on whether the parent groups/roles allow them.

OK

Accepts changes and closes the dialog.

Cancel

Does not retain the changes and closes the dialog.

Help

Displays the help document about this feature.

Previous Topic Next Topic