You can access Talent Management security to hide restricted records in report results. To hide restricted results, you link your report to the existing domain security in Talent Management.
Restricting results is different than restricting access to reports themselves. This topic covers how you can restrict results. Talent Management help contains a topic that describes how to hide reports.
User reports (reports that run in the end-user environment) do not use domain restrictions. Security is based on the information that a user is permitted to access. For example, the users that a supervisor is permitted to access. For information about user report security, see User Report Security
To prevent users from accessing restricted entities, Talent Management uses domains. A domain is an attribute assigned to major entities in Talent Management. The security system determines which users have access to which domains. As it applies to report results, reports only return entities to a user if the user has access to the entity's domain.
Some minor entities, such as Employee Status, do not have a domain attribute.
Users are assigned to roles, which restrict their access to domains (and therefore the entities in the domain). For example, someone in the Manufacturing role might be domain restricted to see only entities in the Manufacturing domain. If a learning administrator creates a new learning item, and puts it in the "Sales" domain, then users in the Manufacturing role cannot see it.
To use Talent Management security in report results for an administrator, you insert syntax into the WHERE clause. The syntax is interpreted at runtime by Talent Management to generate a more complex query for domain filtering. The object of WHERE clause takes the syntax:
[security:the domain restricted entity]
The keyword "security" declares that this part of the WHERE clause is for domain filtering. Substitute "the domain restricted entity" with the table that you want to apply the security filter on. The table must have a DMN_ID column. See the list of tables available for domain restriction or use the data dictionary to find your table. For example, if you use the pa_student entity for domain restriction, type:
[security:pa_student]
The syntax [security:pa_student] filters all records in the return where the report runner is denied access to users (students) because of the domain associated with the user record. If the report runner is in the manufacturing domain and is restricted from seeing users in the sales domain, the report returns no users from the sales domain.
Choose the table/entity that closely matches your SELECT statement. For example, if you write a report to return users, use the user entity (pa_student table). If you write a report to return learning items, use the learning item entity (pa_cpnt). If you write a report to return the users enrolled in a given learning item, think about how you want to restrict the report.
If the report lists users, and the learning items they are assigned into, then you might want to restrict by user.
If the report lists learning items, and the users who are enrolled into them, you might want to restrict by learning item.
Remember to test your report in Talent Management to check its behavior.
The following SQL query selects the user ID, first name, and last name from the pa_student table. There are additional features in the SQL statement, but this example concentrates on the security feature.
Use the Special comment characters in the where clause to prevent the where clause from executing while you design the SQL statement.
SELECT a.stud_id, a.lname, a.fname
FROM pa_student a
WHERE a.active = ?
/** AND a.stud_id in [UserSearch]
AND [security:pa_student a]
ORDER BY [order_by_parameter OrderBy "FNAME=a.fname;LNAME=a.lname"]
*/
If the data in the table is as follows:
| STUD_ID | Active | LNAME | FNAME | DMN_ID |
|---|---|---|---|---|
| GW | Y | Washington | George | Manufacturing |
| TJ | Y | Jefferson | Thomas | PUBLIC |
| AL | Y | Lincoln | Abe | Sales |
| TR | N | Roosevelt | Theodore | Manufacturing |
| RR | Y | Reagan | Ronald | Administration |
The WHERE clause returns the following students under report runners with access to domains:
| Report runner with access to... | Can return these users... |
|---|---|
| Manufacturing | George Washington, Thomas Jefferson, Theodore Roosevelt |
| PUBLIC | Thomas Jefferson |
| Sales & Administration | Thomas Jefferson, Abe Lincoln, Ronald Reagan |