Apply security filters to report model items

The difference between "security login name" and "Security user:

2. "Security Login Name" is added in the following way: <Server Name> --> Security --> login name, right-click and choose "New login name"
4. "Security user": users of specific database -- Security --, right-click and choose "New User". In the pop-up "Database User Interface", the user name can be customized as needed, the login name must be an existing "Security Login Name"
   
6. The principle of applying security filter to report model items is that a field is required to store the corresponding Windows Logon account in the table to enable security filter, and an adventureworks data employee table is used as an example. Loginid stores the Windows Logon account of an employee. The built-in getuser () function of reporting Serivce provides an account for the current login user, and uses expressions to filter information that is not the current user, such as: loginid = getuser (), you can exclude the data that the current user does not see.
   
   
8. In addition to the correct expression, perform the following steps:
2. The getuser () filter expression (assumed name: useridfilter) is set as follows:
1. Useridfilter, attribute isfilter is set to true,
2. Useridfilter. Set the property "hidden" to "true". This identifier is generally not visible to users.
3. Select the entity to which the useridfilter belongs,
1. Select"Securityfilters"Properties, and then click the ellipsis (.... Will open"Attribute reference Set Editor"Dialog box.
2. Click"Add".
3. Will open"Security filter attributes"Dialog box.

4. In"Field"List, select"Useridfilter". Click "OK"

4. Go to the report center. Assume that the report model we use is "Adventure works ".

1. Double-clickAdventure worksAnd then click"Model item security".

2. Selected"Protect the items of this model separately"Check box. To apply model item security, select this check box

3. SelectAdventure worksTop node.

4. Select"Assign read permission to the following users and groups (separated by semicolons".

5. TypeEveryoneAnd then click"Application".

6. Now, the entire report model is visible to all users with the report model permission.

7. Expand the "employee" entity. Select the "useridfilter" attribute.

8. Select "Assign read permission to the following users and groups (separated by semicolons.

9. To grant access permissions to el0 and garrett1, type <computername> \ cancel0; <computername> \ garrett1, and then click Apply ".

10. Verify the Security Settings of Rachel Valdez

1. use the report designer to create a simple report that contains only one field of the employee entity: loginid, and then save the report "Report 1"
2. right-click Internet Explorer , and then click RUN identity
3. In the "User Name" box, type / cancel0 .

4. In the password box, type pass12, word .

5. click "OK"

6. open report 1. Only one row of data is displayed, and only el0's data is displayed.