SQL permissions issue when updating to 8.9.18.0

Good morning. Just updated to 8.9.18.0 and had an issue with updating the remote SQL db. I was running 8.9.13.0 (having to coordinate the upgrade which requires a db update – but it wouldn’t run because of what I think that it is a permissions issue to the SQL server?). I am logged on as a “user” when I got the update error in RDM – then I logged on as a domain admin directly on the SQL server and manually ran the upgrade script and it seems to have worked for RDM to connect to the data source (but SQL query reported back some errors itself). I can use RDM now and seem to be able to use the SQL data source OK.
My user account has full access to the RDM db on the SQL server, but public access to the SQL server itself. My domain admin account has full access to the SQL server, DB's, etc. Do you know what permissions are needed on SQL to run the db update scripts (as a normal user)? Also, can you tell if I should be concerned about any of the errors reported when I manually ran the SQL update script?

Thanks