Security Filter

gvolkov · 2011-03-04

I am trying to setup a Role that would only allow viewing inventory items 1000..2000

I am on SQL and after setting up Security Filter Item: No.='1000..2000' in my new custom Role's permissions, i am unable to view the item card. I am getting error:

Microsoft Dynamics NAV Classic

You do not have permission to read the Item table.

OK

without security filter set for an item range, i can read the item card just fine.
anyone done this?

jaiverma2k2 · 2011-03-06

gvolkov wrote:

I am trying to setup a Role that would only allow viewing inventory items 1000..2000

I am on SQL and after setting up Security Filter Item: No.='1000..2000' in my new custom Role's permissions, i am unable to view the item card. I am getting error:
Microsoft Dynamics NAV Classic
You do not have permission to read the Item table.
OK

without security filter set for an item range, i can read the item card just fine.
anyone done this?

Execute permission is also required, the permission need to set is :
Read - Yes, Execute - Yes, Security Filter - No. - 1000..2000

gvolkov · 2011-03-07

still doesnt work....

btw.. the execute field is non-editable, i did it thru the table though.

MBerger · 2011-03-07

What i am guessing is that NAV tries to open the item card on one of the items outside of the allowed range, giving you the error.

jannestig · 2011-03-08

DO these items belong to either a seperate product group or item catagory ?

It would probably be easir to apply a filter there other then the main key

gvolkov · 2011-03-08

item no. is just an example. lets say that i want to apply a filter to "Item Category Code", it still would not work. I even tried with a single item, and then tried a previous suggestion -

What i am guessing is that NAV tries to open the item card on one of the items outside of the allowed range, giving you the error.

That didnt work either. I start to wonder if this feature even works.

Johannes_Nielsen · 2011-03-09

I'm getting the same result

gvolkov · 2011-03-09

I also tried in Cronus and it doesnt work there either. I thought maybe its something custom on the item form. If nobody here knows the answer i will contact Microsoft support on this.

patrickverhoeven · 2011-05-09

Take a look at this: http://msdn.microsoft.com/en-us/library/dd301449.aspx

Regards,
Patrick

Andwian · 2011-05-10

Add a new role with permission:
T27, Read: Indirect, Execute: Yes.

Give the user the role you create and this new role.

Security Filter

Comments

Categories