|Applies To||RSA Product Set: RSA Via Lifecycle and Governance|
RSA Version/Condition: All
|Issue||Supervisors might have read access to a few of the default or custom reports created in RSA Via L&G. These reports might provide details of other users too. You need supervisors to only view results specific to their subordinates and not all the users. This can be achieved by using the dynamic variable CurrentUserID.|
|Resolution||The built in dynamic variable CurrentUserID can be used to restrict the user set to the subordinates. This will require creating a report definition by joining all access views (user id) to the users table and making sure that the user's supervisor matches to CurrentUserID.|
Note that CurrentUserID shown in the examples below will always be replaced with the ID of logged in user when running report.
Below is a sample query that provides the list of subordinates access:
(SELECT pUser.USER_ID, puser.FIRST_NAME, puser.LAST_NAME, pUAA.APPLICATION_NAME, pUAA.ACCOUNT_NAME,