Hi there,
I have built a query into VBA in the customisation of the Journal Transaction screen. I need to read a field in UserRec table in the system database. What server role / permissions do I need to give the user/group as all I need to do is read the table so don't want to assign more control than i need to the user. If i use Sysadmin Server role it works but that is giving the user too much control. If I don't assign sysadmin, I get the error "The server principal xxxuser is not able to access the database SLSYSTEM under the current security context"
Does anyone have any suggestions?