Hello, I recently took a full backup of our Live database and created a new training database to load some test objects in. My users our getting various permissions errors, one common one is “You do not have permission to read teh Object table”, not sure as to why due to the fact the permissions were copied over from the Live database. I have synchronized all logins to no avail. Any help is greatly appreciated!
Are you using the same Navision license file on both databases?
Yes we are. New to this is that wrong?
Ok, update its seems not random users can access it but others still cannot…
Sorry I meant random users can access but others still cannot…
Is the new database on the same sql server as the original, and are you using Windows Auth or Database Auth?
Hello, same server as the original and we are using Windows Auth.
You might want to take a look at security and user setups in SQL Server, to ensure that your problem users are properly configured. Making and restoring a backup of a NAV database doesn’t automatically copy user credentials over to the new database.
Thanks George, I will check out their permissions.