Deep discussion between the GP experts was done through the days, and the simplest option was to remove “SQLLastUser” from DEX.ini and mark the DEX.ini “Read Only” as discussed in this article.
However, there were side effects on this solution and alternatives explained by David Musgrave, checkout his post here.
Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
mohdaoud@gmail.com
mohdaoud.blogspot.com
Vaidy discovered a good security option in Smart List security! Are you having problems in displaying the data in your customized smart list sourced from SQL Tables? Checkout the below task:
Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
mohdaoud@gmail.com
mohdaoud.blogspot.com
Have you ever wanted to activate the account level security but didn’t find the where to assign users to accounts? Well you will find the answer here, there is nothing line “Field Level Security” to link account to users, instead there is an organizational structure positions that linked to your accounts, and your users will be linked to the needed positions, below are the steps required to set this up:
1. Go to “Microsoft Dynamics GP menu >> Tools >> Setup >> Company >> Company” and activate the module by checking “Account Security”:
2. Go to “Microsoft Dynamics GP menu >> Tools >> Setup >> System >> Org Structures” and define your company positions:
3. Go to “Cards >> Financial >> Account >> Select an account >> Organization button” and link the accounts to the positions:
4. Go to “Microsoft Dynamics GP menu >> Tools >> Setup >> System >> User >> Select a user >> Organization button” and link the user to a position:
That’s it, Enjoy!
Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
mohdaoud@gmail.com
mohdaoud.blogspot.com
