Security Filters of NAV not working in Web Services

swapnil1985

Hello All,

I am trying to set Security filters for Table Data of Job (table 167) as follows
In Permission Table:


Then i am trying to access the Job table data through below code through web services:
ddljob.DataSource = JobList_serv.ReadMultiple(null, null, 0);
ddljob.DataTextField = "Description";
ddljob.DataValueField = "No";
ddljob.DataBind();

But getting the error "You do not have permission to read Job Table".

This security filter is working correctly for Classic Client and RTC. for this windows user job table is showing data of only No. = 'A003_A'. But on Web through web service it is showing the above error.

Please Help me out..

Thanks in Advance

Swapnil Mehta

Gabor_Pesti

Hi,

Thanks for finding this issue. Unfortunately it seems to be a bug in the product. I managed to reproduce it both in the RTM and in the SP1 version. I logged now this in our internal bug tracking system, however I suggest to report it through the official channels as well to increase the chance we can create a hotfix for this.

It seems that the Read method on the service still works with Security Filter, so if you know the key of the records in the table you are interested in, then you can access the data you need. However I have no idea how to get the list of keys.

swapnil1985

If you want to make work security filters in NAV Pages then in OnOpenPage trigger of every page where you want to have effect of security filters write code: Record.SetPermissionOnFilters

Thanks & Regards,
Swapnil

Ravi_Thakkar

Gabor Pesti wrote:

Hi,

Thanks for finding this issue. Unfortunately it seems to be a bug in the product. I managed to reproduce it both in the RTM and in the SP1 version. I logged now this in our internal bug tracking system, however I suggest to report it through the official channels as well to increase the chance we can create a hotfix for this.

It seems that the Read method on the service still works with Security Filter, so if you know the key of the records in the table you are interested in, then you can access the data you need. However I have no idea how to get the list of keys.

I thing it's not a bug.
In forms also, same thing is there.
and it can be solved as Swapnil suggested above.