Open Forum

Expand all | Collapse all

Connecting w/ DBA, Admins

  • 1.  Connecting w/ DBA, Admins

    Posted Jan 05, 2017 08:13 PM

    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
    ------------------------------
    NAVUG Summit - Post


  • 2.  RE: Connecting w/ DBA, Admins

    TOP CONTRIBUTOR
    Posted Jan 06, 2017 04:18 AM

    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

    NAVUG Summit - Post


  • 3.  RE: Connecting w/ DBA, Admins

    Posted Jan 17, 2017 08:14 PM
    Franz,
    Thank you for the links it is much appreciated. Very helpful.

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

    NAVUG Summit - Post


  • 4.  RE: Connecting w/ DBA, Admins

    Posted Jan 18, 2017 01:01 PM
    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
    ------------------------------

    NAVUG Summit - Post


  • 5.  RE: Connecting w/ DBA, Admins

    Posted Jan 06, 2017 08:43 AM

    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

    NAVUG Summit - Post


  • 6.  RE: Connecting w/ DBA, Admins

    Posted Jan 17, 2017 08:16 PM
    Thanks Doug,
    I can definitely see where this will be useful. Much appreciated.

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

    NAVUG Summit - Post


  • 7.  RE: Connecting w/ DBA, Admins

    TOP CONTRIBUTOR
    Posted Jan 06, 2017 10:12 AM

    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

    NAVUG Summit - Post


  • 8.  RE: Connecting w/ DBA, Admins

    TOP CONTRIBUTOR
    Posted Jan 08, 2017 03:28 PM

    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

    NAVUG Summit - Post


If you've found this thread useful, dive deeper into User Group community content by role