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 :)
to learn more about dynamics nav you could start with following tutorials
https://m.youtube.com/channel/UCXSvIwtWuxwVwH3bP_uJZnQ (very good)
if you like to read about dynamics nav follow https://msdn.microsoft.com/en-us/library/hh173988(v=nav.90).aspx
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.
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:
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.
for security issues follow https://msdn.microsoft.com/en-us/library/dd355294(v=nav.90).aspx