A security filter restricts the set of data values that a named group of users can read from a database. A security filter is made up of one or more queries.
Security filter query syntax
A security filter query is a comparison of a column and data value, as shown in the following example:
[Demo].[Household].[Town] EQ Big Bear Lake
The query must conform to the following syntactical rules:
Object names, such as columns and tables, are case sensitive.
The set of available operators is:
EQ, NE, GE, GT, LE, LT
A string value does not require quotation mark delimiters (" or ').
Using multiple security filter queries
A security filter supports multiple queries. The filter joins queries using a logical AND if a link exists in the repository between the queries. If the repository does not provide a link between the queries, the filter joins the queries using a logical OR. For example, the following two queries in a security filter:
[Demo].[Household].[Town] EQ Brisbane
[Demo].[Customer].[Gender] EQ F
are equivalent to:
([Demo].[Household].[Town] EQ Brisbane)
AND
([Demo].[Customer].[Gender] EQ F)
The following two queries that have no link in the repository:
[FS].[Customer].[Occupation] EQ Director
[Demo].[Customer].[Gender] EQ F
are equivalent to:
([FS].[Customer].[Occupation] EQ Director)
OR
([Demo].[Customer].[Gender] EQ F)
Security filter management
The Security filters page allows the administrator to create, modify, or delete a security filter and specify one or more queries to control access to data.
Clicking Actions provides the following choices:
Refresh
Choose Refresh to update the list of security filters. Any changes that another administrator made to the security filters available are displayed.
New
Choose New to define a new security filter. In New security filter group, type the name and a description. Then, choose New and type a query. Choose Test query to validate the query. If valid, the application displays the records obtained, as shown in Figure 1‑10. Choose OK to add the query. The query appears in the list of queries for the security filter.
Repeat the procedure to add a query if the security filter requires more queries.
Choose OK. BIRT Analytics revalidates the queries. If any query contains an error, BIRT Analytics does not save the security filter. Correct the error and choose OK again. The security filter appears in the list of filters.
Figure 1‑10 Creating a security filter
Modify
In the list of security filters, select a security filter. Then, click Actions and choose Modify to change the settings for the filter. In Updating group, type the name and a description. To add a new query to the filter, choose New. To modify or delete a query, select the query. Then choose Modify or Delete.
Choose Test query to validate the query. If valid, the application displays the records obtained. Choose OK to add the query. The query appears in the list of queries for the security filter. Choose OK to update the security filter.
Create As
In the list of security filters, select a security filter. Then, click Actions and choose Create As to define a new filter containing the settings specified for the selected filter. In Create as, type the name and a description for the new filter. To add a new query to the filter, choose New. To modify or delete a query, select the query. Then choose Modify or Delete.
Choose Test query to validate each new or modified query. If valid, the application displays the records obtained and adds the query. Choose OK. The security filter appears in the list of current filters.
Delete
In the list of security filters, select a security filter. Then, click Actions and choose Delete to remove a security filter. In Deleting group, the name, description, and filter queries appear.
Choose OK. A prompt appears. Choose Yes to confirm deleting the filter.
Object names, such as columns and tables, are case sensitive.