SPARUL INSERT access denied even after granting update permission

Question

I have a Virtuoso server running on a remote machine and can access the conductor UI by logging in as dba user. I have created a graph using Linked Data -> Quad Store Upload on which I am able to run select SPARQL queries from Linked Data -> SPARQL. However, when I run INSERT DATA query I am facing the following error.

Virtuoso RDF02 Error SR619: SPARUL INSERT access denied: database user 108 (SPARQL) has no write permission on graph http://localhost:8890/dummy

I have checked on System Admin -> User Accounts that the users SPARQL/dba have SPARQL_UPDATE, SPARQL_SELECT role. I have checked Linked Data -> Graphs -> Roles Security and it seems fine. I have the same setup on my local machine on which I initially faced a similar permission issue but after granting roles SPARQL_UPDATE, SPARQL_SELECT role it was resolved.

Please suggest how can I avoid this error.

Answer 1

A workaround is proposed in virtuoso-opensource/issues/1094:

run the following in the ISQL console,

DB.DBA.RDF_DEFAULT_USER_PERMS_SET ('nobody', 7);

A second option it to change the Usert type of the SPARQL user from SQL/ODBC to SQL/ODBC and WebDAV (see here for the original quote).

Option 2 worked for me (virtuoso-opensource, version: 07.20.3235).