Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Sherman Daley]

Hi there:

I recently join the NAV user group, I am a DBA and somewhat new to the NAV environment and looking for some good people to connect with. Certainly, if you are a DBA or a SysAdmin and you like to share the knowledge you have gained I would love to connect with you.   

Most of my previous environment I was able to manage some of what is currently managed by NAV i.e security, index etc. and now I find I need to learn NAV and its structure to get the sense I am addressing issues correctly.  Hence my motivation to make some connects to try to reduce my learning curve. If you have any suggestions or words of wisdom they are welcome.

Either way, I would love to make some new NAV contacts. Thanks 🙂

——————————
Sherman Daley
DBA / Developer .Net
Event Network Inc.
San Diego CA
——————————

[Franz Kalchmair]

hi sherman,

welcome!

to learn more about dynamics nav you could start with following tutorials

https://m.youtube.com/channel/UCXSvIwtWuxwVwH3bP_uJZnQ (very good)

https://m.youtube.com/playlist?list=PLoS7gV-LINmnV0DWUgFo9ZTIzddqHLXli

https://m.youtube.com/playlist?list=PLfmcUW0fYzCYv7nvzsPPT105WQ1Fg2o2R 

if you like to read about dynamics nav follow https://msdn.microsoft.com/en-us/library/hh173988(v=nav.90).aspx

regards

franz

——————————
Franz Kalchmair
Dynamics NAV Engineer and Consultant
Microsoft MVP
Vienna
————————————————————————-

[Sherman Daley]

Franz,
Thank you for the links it is much appreciated. Very helpful.

——————————
Sherman Daley
DBA / Developer .Net
Event Network Inc.
San Diego CA
——————————
——————————————-

[Sherman Daley]

Hey Franz,
Your video links turned out to be perfect for what I was looking for right now.
We are moving to 2016 and needed some video the would help walk me through the front end and they nailed it.
Thanks

——————————
Sherman Daley
DBA / Developer .Net
Event Network Inc.
San Diego CA
——————————
——————————————-

[Doug Huras]

You mention security.  It can be a bear to deal with.  We have had some success with a product called NAV Easy Security from MergeTool.  You may be interested in it.  

http://mergetool.com/default2.html?gclid=Cj0KEQiAnb3DBRCX2ZnSnMyO9dIBEiQAOcXYHzZyurSA0KjbP2R4kPfUnvkYEoCMBlNYaDdMOYD1OvYaAi9E8P8HAQ

——————————
Doug Huras
Senior Software Developer
Home Hardware Stores Limited
St Jacobs ON
————————————————————————-

[Sherman Daley]

Thanks Doug,
I can definitely see where this will be useful. Much appreciated.

——————————
Sherman Daley
DBA / Developer .Net
Event Network Inc.
San Diego CA
——————————
——————————————-

[Ian Ray]

Welcome!

I would also recommend Easy Security. From a database perspective, Easy Security is especially useful to an administrator as it allows importing data from the SQL profiler to create a unique permission set. Practically, this means tasks can be performed in a test environment, required access recorded, and all relevant permissions to perform those tasks merged into a production environment. Additionally, Easy Security can limit page access which is something that would take countless hours to do otherwise considering the quantity of pages.

The alternative is a tedious exercise of manually setting the particular “yes/indirect” “read/insert/modify/delete” permissions on each table for each task. This involves the “users” and “permission sets” pages. A permission set can be created by first running through a desired task as a test user in a test environment, noting each table access message, setting the correct permission in a new permission set, copy/paste the rows of that test permission set into a production environment permission set, and finally assigning the user(s) the permission set in a production environment. In my opinion, the worst part of this sort of manual process is assigning the permission set to all the relevant users which is another thing Easy Security takes care of by allowing grouping of users.

The help page for permission sets in NAV:

https://msdn.microsoft.com/en-us/library/dd568740(v=nav.90).aspx

There are also many stock permission sets in NAV. These can be quite useful, but I would recommend examining them prior to assigning them to users as some of these stock permission sets grant permissions to things you likely don’t want to.

——————————
Ian Ray
Cypress Grove
Arcata CA
————————————————————————-

[Franz Kalchmair]

for security issues follow https://msdn.microsoft.com/en-us/library/dd355294(v=nav.90).aspx

regards

——————————
Franz Kalchmair
Dynamics NAV Engineer and Consultant
Microsoft MVP
Vienna
————————————————————————-