PER_SHARE_INFORMATION table not returning any data

Question

I came across the following code in one of the seeded query, but it isn't returning any data when executed. Could anyone help me understand what information is supposed to be stored in this table? Additionally, what settings or configurations need to be in place for the data to be populated in this table?

SELECT 1 FROM PER_SHARE_INFORMATION SI WHERE SI.GRANTEE_PERSON_ID = (SELECT NVL(HRC_SESSION_UTIL.GET_USER_PERSONID,-1) FROM DUAL)

RVohra · Answer

If the user is a normal employee or HR person without special "shared access", then:

* No rows will exist for them
* The query returns no data
* This is expected behavior

This table usually remains empty unless your organization has turned on Workforce Sharing.

* The Share Data Access task adds rows to PER_SHARE_INFORMATION, and the Revoke Share Data Access process deletes them.* There isn't an audit on the table.
* Once the data is deleted, it can't be recovered. But you can use the Share Data Access task to manually add it again.
* The data in the table is used by the person security profile. If configured, your person security profile includes the rows in the table when determining data security for your tasks.