Hi - Let me start by stating for the record I am not a developer! My question relates to data encryption within Nav. I believe it was first introduced in Nav 2009 - (although I know that it can be applied to previous versions by the same technology). In my example the bank account details are encrypted. I do not believe that this is anything to do with set up but is it something that can be turned on/off. Is it applied at SQL Db level? Can anyone point me in the direction of where I can read more up about how the encryption is applied etc.
The encryption is not applied at database level. When we talk about data encryption in NAV 2009, then it means that Dynamics NAV is encrypting the communication between the NAV server and the NAV clients. This prevent someone from intercepting this communication, which is especially important if you run NAV over the internet.
You can read more about the features in NAV 2009 R2 here:
If what you need is to encrypt at SQL database level, then you should contact a SQL security specialist. It's something which should be handled with out most care, and is in general not recommended.
In general the NAV + SQL user permission setup should be able to cover-up access to who may see data.