LearningNeeds Report security adding new columns

[abjeh22]

Hi,

I am adding 3 columns from the PA_STUD_USER table to the Learning Needs Report. The report already uses the security line [security:pa_student s] but after adding the additional fields the security is no longer working. It shows all entries instead of only those the user is allowed to see. The table PA_STUD_USER does not have the DMN_ID column but does have the STUD_ID field. Why is the security no longer working? Do I need to use something different than the LearningNeedsDataSet for this to work with additional fields? In the select on PA_STUD_USER I also tried adding the PA_STUDENT table and pulling the DMN_ID and then additionally adding the security line to this select as well but it still returns all entries.

Any ideas how to get the security to work?

	 	(
  		SELECT s.stud_id as EME, s.dmn_id AS EMEdomain,
  		 i.stud_id as EMPid , 
   		decode (i.user_value, 'Exempt', 'Yes', ' ') AS EEempt , 
  		o.user_value AS EEgrp , p.user_value as Pernr
  		   
            FROM pa_student s,
               pa_stud_user AS i 
              INNER JOIN pa_stud_user AS o ON o.stud_id = i.stud_id 
               AND o.col_num = '5'  
              INNER JOIN pa_stud_user as p on p.stud_id = i.stud_id
               AND p.col_num = '7'   
            WHERE i.col_num = '2' 
            and s.stud_id = i.stud_id
           /** AND [security:pa_student s]  */
    		) EEINFO,

Thanks

JEH

[abjeh22]

Looks like the new copied report was not added to the security role and therefore was not restricting the entries.

Thanks
JEH

[abjeh22]

I have been importing the report into LMS. The standard report works fine but adding these fields seems to disable the security.

Thanks
JEH

[abjeh22]

I have been importing the report into LMS. The standard report works fine but adding these fields seems to disable the security.

Thanks
JEH

[jorgecampos]

Are working with PRD or People Analytics? If you are working with PRD and testing the query or the report in PRD, keep in mind that the security mechanism is not used in PRD. The security mechanism only work when running reports in the system.