This HTML5 document contains 74 embedded RDF statements represented using HTML+Microdata notation.

The embedded RDF content will be recognized by any processor of HTML5 Microdata.

Subject Item

n2:OdsSPARQLAuth

rdf:type

sioct:Comment atom:Entry

dcterms:created

2017-06-13T06:03:29.546028

dcterms:modified

2017-06-29T07:32:28.784469

rdfs:label

OdsSPARQLAuth

foaf:maker

n11:this n9:this

dc:title

OdsSPARQLAuth

opl:isDescribedUsing

n29:rdf

sioc:has_creator

n7:this n23:this

sioc:attachment

n17:png n18:png n19:png n20:png

sioc:content

%META:TOPICPARENT{name="ODSIndex"}% ---+ Executing SPARQL Update queries through an OAuth-protected Virtuoso SPARQL endpoint Virtuoso reserves the path <b>/sparql-auth/</b> (e.g., <b><code><nowiki>http://&lt;cname&gt;:&lt;port&gt;/sparql-auth</nowiki></code></b>) for provision of SPARQL services with user authentication. This endpoint allows specific SQL accounts to perform SPARQL Update (formerly SPARUL) queries over the SPARQL protocol. </b><code><nowiki>SPARQL_UPDATE</nowiki></code> must be granted to an (ODS) user to perform operations on physical triples and for the user to login via SQL data connections (ODBC, JDBC, OLE DB, ADO.NET, etc.). The necessary steps are as follow -- 1. Go to <b><code><nowiki>http://&lt;cname&gt;:&lt;port&gt;/conductor</nowiki></code></b>, where <code>&lt;cname&gt;:&lt;port&gt;</code> are replaced by your local server values. 1. Log in as the <code>dba</code> user. 1. Go to *System Admin* -> *User Accounts* -> *Users* %BR%%BR%<img src="%ATTACHURLPATH%/usr1.png" style="wikiautogen"/>%BR%%BR% 1. Click *Edit* for the user needing <code><nop>SPARQL_UPDATE</code>, e.g., <code>demo</code>: %BR%%BR%<img src="%ATTACHURLPATH%/usr2.png" style="wikiautogen"/>%BR%%BR% <img src="%ATTACHURLPATH%/usr3.png" style="wikiautogen"/>%BR%%BR% 1. In the form that returns: 1 Set *User type* to *SQL/ODBC and WebDAV* 1. From the list of available Account Roles, select <b><nop>SPARQL_UPDATE</b> role and click the <b>>></b> button, to add it to the list on the right. * <img src="%ATTACHURLPATH%/usr4.png" style="wikiautogen"/> 1. Click *Save*. <i><b>Note:</b> If there is a table used in a RDF view, and <code><nowiki>SPARQL_SELECT</nowiki></code> (or <code><nowiki>SPARQL_UPDATE</nowiki></code> which inherits <code><nowiki>SPARQL_SELECT</nowiki></code>) is not granted on this table, then an unqualified <code><nowiki>SPARQL SELECT</nowiki></code> (i.e., without <code>FROM</code> clause, implying <code>FROM</code> all graphs) will return an access violation error as the user account has no permissions to read it. In other words, an account must have <code><nowiki>SPARQL_SELECT</nowiki></code> privileges on all tables included in any RDF view in order to select on all graphs.</i> ---+++Related * [[http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtSPARQLEndpointProtection][Safeguarding your Virtuoso-hosted SPARQL Endpoint]] * [[http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideSPARQLEndpointProtection][SPARQL Endpoint Protection Methods Collection]] * [[http://docs.openlinksw.com/virtuoso/][Virtuoso documentation]] * [[http://docs.openlinksw.com/virtuoso/rdfsparql.html#rdfsupportedprotocolendpoint][SPARQL Service Endpoint]] * [[http://docs.openlinksw.com/virtuoso/rdfsparql.html#rdfsupportedprotocolendpointuri][Service Endpoint Security]] * [[http://docs.openlinksw.com/virtuoso/rdfsparql.html#sparqwebservicetbl][Managing a SPARQL Web Service Endpoint]] * [[http://docs.openlinksw.com/virtuoso/rdfsparql.html][SPARQL]] * [[http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuide][Virtuoso Tips and Tricks Collection]] * [[http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtSPARQLDET][SPARQL Endpoint DET Configuration Guide]] * [[http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtSPARQLSecurityWebID][WebID Protocol & SPARQL Endpoint ACLs Tutorial]] * [[http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtOAuthSPARQL][SPARQL OAuth Tutorial]] * [[http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideSPARQLEndpoints][Securing SPARQL endpoints]] * [[http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtAuthServerUI][Virtuoso Authentication Server UI]] * [[http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtSPARQLSSL][Manage a SPARQL-WebID based Endpoint]] * [[VirtODSSecurityWebID][WebID Protocol Support in OpenLink Data Spaces]]. * Manage ODS Datadspaces Objects WebID Access Control Lists (ACLs): * [[ODSBriefcaseWebID][ODS Briefcase WebID based ACL Guide]] * [[ODSBriefcaseWebIDPerson][Person Entity WebID based ACL Guide]] * [[ODSBriefcaseWebIDGroup][Group Entity WebID based ACL Guide]] * [[ODSBriefcaseWebIDPublic][Public WebID based ACL Guide]] * [[ODSFeedManagerWebIDACL][ODS Feed Manager WebID based ACL Guide]] * [[ODSFeedManagerWebIDACLPerson][Person Entity Specific ACL]] * [[ODSFeedManagerWebIDACLGroup][Group Entity Specific ACL]] * [[ODSFeedManagerWebIDACLPublic][Public Specific ACL for anyone with a WebID]] * [[ODSCalendarWebIDACL][ODS Calendar WebID based ACL Guide]] * [[ODSCalendarWebIDACLPerson][Person Entity Specific ACL]] * [[ODSCalendarWebIDACLGroup][Group Entity Specific ACL]] * [[ODSCalendarWebIDACLPublic][Public Specific ACL for anyone with a WebID]] * [[ODSBookmarksWebIDACL][ODS Bookmark Manager WebID based ACL Guide]] * [[ODSBookmarksWebIDACLPerson][Person Entity Specific ACL]] * [[ODSBookmarksWebIDACLGroup][Group Entity Specific ACL]] * [[ODSBookmarksWebIDACLPublic][Public Specific ACL for anyone with a WebID]] * [[ODSAddressBookWebIDACL][ODS Addressbook WebID based ACL Guide]] * [[ODSAddressBookWebIDACLPerson][Person Entity Specific ACL]] * [[ODSAddressBookWebIDACLGroup][Group Entity Specific ACL]] * [[ODSAddressBookWebIDACLPublic][Public Specific ACL for anyone with a WebID]] * [[ODSPkiSetup][Guide for Set up a X.509 certificate issuer and HTTPS listener and generate ODS user certificates]] * [[ODSSetupSSL][Configure Virtuoso+ODS instance as an X.509 Certificate Authority and HTTPS listener]] * [[http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtSetupSSL][Configure Virtuoso instance as an X.509 Certificate Authority and HTTPS listener]] * [[VirtODSPubSubHub][Setting up PubSubHub in ODS]] * [[VirtPubSubHub][PubSubHubBub Demo Client Example]] * [[VirtFeedPubSubHub][Feed subscription via PubSubHub protocol Example ]] * [[VirtPubSubHubACL][Setting Up PubSubHub to use WebID Protocol or IP based control lists]] * [[OdsKeyImport][CA Keys Import using Conductor]] * [[ODSGenerateX509Certificate][Generate an X.509 Certificate hosted WebID Guide]] * [[ODSGenerateWebIDX509CertOSKeystore][Generate an X.509 Certificate (with a WebID watermark) to be managed by host operating system keystore]] * [[ODSGenerateWebIDX509CertBrsKeystore][Generate an X.509 Certificate (with a WebID watermark) to be managed by a browser-based keystore]] * [[ODSWebIDIdP][Using Virtuoso's WebID Verification Proxy Service with a WebID-bearing X.509 certificate]] * [[ODSWebIDIdpProxy][Using Virtuoso's WebID Identity Provider (IdP) Proxy Service with an X.509 certificate]] * [[ODSBriefcaseWebIDShareFile][ODS Briefcase WebID Protocol Share File Guide]] * [[http://esw.w3.org/topic/foaf+ssl][WebID Protocol Specification]] * [[https://foaf.me/simpleLogin.php][Test WebID Protocol Certificate page]] * [[http://test.foafssl.org/cert/][WebID Protocol Certificate Generation page]] CategoryODS CategoryOpenSource CategoryWebSite

sioc:id

faabe0c431e98ce5f992386ab6ad1564

sioc:link

n2:OdsSPARQLAuth

sioc:has_container

n15:ODS

n26:has_services

n27:item

atom:title

OdsSPARQLAuth

sioc:links_to

n2:OdsKeyImport n4:VirtSPARQLSecurityWebID n2:ODSBookmarksWebIDACLPublic n4:VirtTipsAndTricksGuideSPARQLEndpoints n2:ODSCalendarWebIDACLPerson n4:VirtTipsAndTricksGuide n4:VirtSPARQLDET n8:html n2:ODSBookmarksWebIDACLGroup n2:ODSWebIDIdpProxy n4:VirtSPARQLEndpointProtection n2:ODSBriefcaseWebIDGroup n12:rdfsupportedprotocolendpointuri n12:sparqwebservicetbl n13: n2:ODSAddressBookWebIDACLPublic n12:rdfsupportedprotocolendpoint n2:ODSGenerateWebIDX509CertBrsKeystore n2:ODSAddressBookWebIDACL n2:CategoryWebSite n2:ODSCalendarWebIDACLPublic n2:ODSCalendarWebIDACLGroup n2:ODSAddressBookWebIDACLGroup n2:ODSBookmarksWebIDACLPerson n4:VirtTipsAndTricksGuideSPARQLEndpointProtection n2:ODSAddressBookWebIDACLPerson n2:ODSBookmarksWebIDACL n2:ODSFeedManagerWebIDACLGroup n2:CategoryOpenSource n2:ODSFeedManagerWebIDACLPerson n2:ODSCalendarWebIDACL n4:VirtOAuthSPARQL n4:VirtSetupSSL n4:VirtSPARQLSSL n2:ODSFeedManagerWebIDACLPublic n4:VirtAuthServerUI n21:WebID n2:ODSBriefcaseWebIDPerson n22: n21:WebDAV n24:ssl n25:php n2:ODSBriefcaseWebID n2:ODSFeedManagerWebIDACL n2:ODSGenerateX509Certificate n2:CategoryODS n2:ODSGenerateWebIDX509CertOSKeystore n2:ODSBriefcaseWebIDPublic

atom:source

n15:ODS

atom:author

n9:this

atom:published

2017-06-13T06:03:29Z

atom:updated

2017-06-29T07:32:28Z

sioc:topic

n15:ODS