Hi guys i work in dynamic navision 5.0 in navigation pane menu warehouse department - planing and execution - item then press f5 or list from menu form i need to create user see specified items only as example
item list as following
no description item category
a explain1 sp
b explain2 sp
c explain3 fg
d explain4 fg
my question is i need to create two users
first can see sp and not see fg.
and second can see fg but cannot see sp.
thanks
May I know what did you try?
this meaning you understood what i write
You can not do through roles & permission
You need to do some customization using User Setup table
You can have look at User setup table look at the field Sales Resp Ctr.Filter and codeunit 5700 User Setup Management
You will get idea.
there is not solution or articles are clear because my license dont have permission to open code unit
please help me if there are any thing easy
Then you need to get customized from your partner as you can not assign roles & permission on field basis.
which Licence are you using?
Customer/Partner?
I have one solution but it is not work i create new role then assign this role to this user
then in permission of role i make as following
object name:Object Type Object ID Object Name Read Permission Insert Permission Modify Permission Delete Permission Execute Permission Security Filter
Table Data 27 Item Yes Yes Yes Yes Yes Item: Item Category Code=SP
as above object name item
then
security filter :item category code =sp
but it not work why
Is there any other role assigned with table data 27?
did you synchronize?
yes i synchronize and i added supper role with it
You should not add super role…
I have one solution but it is not work i create new role then assign this role to this user
then in permission of role i make as following
object name:Object Type Object ID Object Name Read Permission Insert Permission Modify Permission Delete Permission Execute Permission Security Filter
Table Data 27 Item Yes Yes Yes Yes Yes Item: Item Category Code=SP
as above object name item
then
security filter :item category code =sp
but it not work why
ensure that there should not be other role added to the user which allows full permission for the item table
i create user then assign permission to it and assign all also but no working any one know how i solve this proplem
What roles did you assign to new user?
i create role test5 then after i create i make asynchronous login this role contain as following
Object Type Object ID Object Name Read Permission Insert Permission Modify Permission Delete Permission Execute Permission Security Filter
Table Data 0 Yes Yes Yes Yes Yes
Table Data 27 Item Yes Yes Yes Yes Yes Item: Item Category Code=SP
Table Data 99000875 Order Promising Setup Yes
Table Data 2000000001 Object Yes
Table Data 2000000002 User Yes
Table Data 2000000003 Member Of Yes
Table Data 2000000005 Permission Yes
Table Data 2000000006 Company Yes
Table Data 2000000007 Date Yes
Table 0 Yes Yes Yes Yes Yes
Form 0 Yes Yes Yes Yes Yes
Report 0 Yes Yes Yes Yes Yes
Data port 0 Yes Yes Yes Yes Yes
Code unit 0 Yes Yes Yes Yes Yes
XML port 0 Yes Yes Yes Yes Yes
Menu Suite 0 Yes Yes Yes Yes Yes
Page 0 Yes Yes Yes Yes Yes
System 0 Yes Yes Yes Yes Yes
this roles contain
I create role naming test then assign to user this role only i assign to user that contain as following
Object Type Object ID Object Name Read Permission Insert Permission Modify Permission Delete Permission Execute Permission Security Filter
Table Data 0 Yes Yes Yes Yes Yes
Table Data 27 Item Yes Yes Yes Yes Yes Item: Item Category Code=SP
Table Data 99000875 Order Promising Setup Yes
Table Data 2000000001 Object Yes
Table Data 2000000002 User Yes
Table Data 2000000003 Member Of Yes
Table Data 2000000005 Permission Yes
Table Data 2000000006 Company Yes
Table Data 2000000007 Date Yes
Table 0 Yes Yes Yes Yes Yes
Form 0 Yes Yes Yes Yes Yes
Report 0 Yes Yes Yes Yes Yes
Data port 0 Yes Yes Yes Yes Yes
Codeunit 0 Yes Yes Yes Yes Yes
XMLport 0 Yes Yes Yes Yes Yes
MenuSuite 0 Yes Yes Yes Yes Yes
Page 0 Yes Yes Yes Yes Yes
System 0 Yes Yes Yes Yes Yes
Delete the table data line with 0
I make this but after i delete data table line 0 it give me message error you don’t have permission to read license agreement table
thanks
You have to provide permissions for table data one by one…otherwise it wont work…