I am migrating an existing database from an older 7.2 release (7.20.3215) to a newer one (7.20.3237). I followed the usual procedure for moving to a new release (checkpoint, shutdown, ensure empty trx file) and had no issues there.

There is a service account created in the database that is used by our application to create and update content in a graph. Since the update, we get an error when the service account attempts to make an update:

`SQ074: Line 1: SP031: SPARQL compiler: Function http://www.openlink.com/schemas/bif#__rdf_long_from_batch_params() cannot be used in the text of SPARQL due to security restrictions.`

 If I change the application to use the dba account, this error does not occur. So I assume that there are additional grants that need to be added to the service account, but I am not seeing anything obvious. Can someone please point me in the right direction?
SQ074 SP031: Function cannot be used in text of SPARQL query due to security restrictions
This is a GitHub Issue
repo:virtuoso-opensource
owner:openlink
Title : SQ074 SP031: Function cannot be used in text of SPARQL query due to security restrictions
Issue date:

--- start body ---
I am migrating an existing database from an older 7.2 release (7.20.3215) to a newer one (7.20.3237). I followed the usual procedure for moving to a new release (checkpoint, shutdown, ensure empty trx file) and had no issues there.

There is a service account created in the database that is used by our application to create and update content in a graph. Since the update, we get an error when the service account attempts to make an update:

`SQ074: Line 1: SP031: SPARQL compiler: Function http://www.openlink.com/schemas/bif#__rdf_long_from_batch_params() cannot be used in the text of SPARQL due to security restrictions.`

 If I change the application to use the dba account, this error does not occur. So I assume that there are additional grants that need to be added to the service account, but I am not seeing anything obvious. Can someone please point me in the right direction?
--- end body ---

None