SPARUL over SPARQL using the http://cname:port/sparql-auth endpoint
Virtuoso reserves the path '/sparql-auth/' for SPARQL service with authenticated SPARUL option. This endpoint allows specific SQL accounts to perform SPARUL over the SPARQL protocol.
"SPARQL_UPDATE" is needed to be granted on a (ODS) user to perform all operations on physical triples and the user to be able allowed to perform SQL/ODBC logins:
- Go to the Virtuoso Administration Conductor i.e. http://cname:port/conductor
- Login as dba user
- Go to System Admin->User Accounts->Users
- Click the link "Edit"
- In the shown form check the "Allow SQL/ODBC Logins" check-box.
- Select from the list of available Account Roles "SPARQL_UPDATE" role and click the ">>" button so to add it to the right-positioned list.
- Click the "Save" button.
Note that if there is a table used in a RDF view, and this table is not granted to SPARQL_SELECT ( SPARQL_UPDATE inherits it ), then select on all graph will return access violation error as the user account has no permissions to read it. Thus the account need to have privileges on all tables included in any rdf view in order to be able to select on all graphs.