Security Filter

gvolkov

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

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

still doesnt work....

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

MBerger

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

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

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

I'm getting the same result

gvolkov

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

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

Regards,
Patrick

Andwian

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

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