It is very simple to implement a column level security.
Steps:
Steps:
1. Identify which column needs security.
2. On the RPD presentation layer, navigate to the subject area, table and the column which you want to enforce security.
3. Double click to open the column property and click on permissions.
2. On the RPD presentation layer, navigate to the subject area, table and the column which you want to enforce security.
3. Double click to open the column property and click on permissions.
4. Uncheck everyone option and select only users or groups you want to show that column.
5. Save the RPD.
6. Create a report with required columns including this column (Quantity_Sold)
7. Login with users whom we have selected in the column permission tab.
8. The report will show with all columns because we have enabled for these users.
5. Save the RPD.
6. Create a report with required columns including this column (Quantity_Sold)
7. Login with users whom we have selected in the column permission tab.
8. The report will show with all columns because we have enabled for these users.
9. When you login with other users with whom we have restricted column access. You would see error as below.
10. Simple trick to fix the issue
11. Open the NQConfig.INI file, you would find “PROJECT_INACCESSIBLE_COLUMN_AS_NULL under security section.
12. By default this option will be “NO”, change to “YES”.
13. Save the file and re-run the services.
14. Login with any users, the report will show all the columns who have access to it and it will show all columns except the restricted column for those who do not have access to that column.
11. Open the NQConfig.INI file, you would find “PROJECT_INACCESSIBLE_COLUMN_AS_NULL under security section.
12. By default this option will be “NO”, change to “YES”.
13. Save the file and re-run the services.
14. Login with any users, the report will show all the columns who have access to it and it will show all columns except the restricted column for those who do not have access to that column.
15. Though we have the Quantity_Sold column in this report, it is not showing because the user doesn’t have the column access.
Posts
