Grant Access to the User for Geocode

In this script, a user with ‘SYSADMIN’ role is used to perform geocode operation. Therefore, these access rights are required to be granted to the user.

grant ALL PRIVILEGES ON database PRESALES to role SYSADMIN;
grant ALL PRIVILEGES ON SCHEMA PRESALES to role SYSADMIN;

-- use any of below query based on the Format which you have created.
grant usage on function geocode(string ,string ) to sysadmin;
grant usage on function geocode(array) to sysadmin;
grant usage on function geocode(object) to sysadmin;

-- changing the requested role.
use role sysadmin;