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

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

Subject Item

n15:this

foaf:made

n2:OdsSPARQLAuth

Subject Item

n11:item

n12:services_of

n2:OdsSPARQLAuth

Subject Item

n13:this

sioc:creator_of

n2:OdsSPARQLAuth

Subject Item

n2:ODSWebIDIdpProxy

sioc:links_to

n2:OdsSPARQLAuth

Subject Item

n2:VirtPubSubHubACL

sioc:links_to

n2:OdsSPARQLAuth

Subject Item

n2:OdsBriefcaseAmazonS3WebIDACL

sioc:links_to

n2:OdsSPARQLAuth

Subject Item

n2:OdsBriefcaseSkyDriveWebIDACL

sioc:links_to

n2:OdsSPARQLAuth

Subject Item

n2:OdsBriefcaseGoogleDriveWebIDACL

sioc:links_to

n2:OdsSPARQLAuth

Subject Item

n2:VirtODSOAuthQA

sioc:links_to

n2:OdsSPARQLAuth

Subject Item

n2:VirtPubSubHubACLDefinePSHSSL

sioc:links_to

n2:OdsSPARQLAuth

Subject Item

n5:ODS

sioc:container_of

n2:OdsSPARQLAuth

atom:entry

n2:OdsSPARQLAuth

atom:contains

n2:OdsSPARQLAuth

Subject Item

n2:ODSAddressBookWebIDACLShareContact

sioc:links_to

n2:OdsSPARQLAuth

Subject Item

n2:ODSBookmarksWebIDACLShareBookmark

sioc:links_to

n2:OdsSPARQLAuth

Subject Item

n2:ODSCalendarWebIDACLShareEvent

sioc:links_to

n2:OdsSPARQLAuth

Subject Item

n2:ODSCalendarWebIDACLShareTask

sioc:links_to

n2:OdsSPARQLAuth

Subject Item

n2:ODSFeedManagerWebIDACLShareSubscription

sioc:links_to

n2:OdsSPARQLAuth

Subject Item

n9:this

sioc:creator_of

n2:OdsSPARQLAuth

Subject Item

n2:ODSSetupSSL

sioc:links_to

n2:OdsSPARQLAuth

Subject Item

n2:OdsBriefcaseDropBoxWebIDACL

sioc:links_to

n2:OdsSPARQLAuth

Subject Item

n2:OdsBriefcaseBoxNetWebIDACL

sioc:links_to

n2:OdsSPARQLAuth

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

n15:this n20:this

dc:title

OdsSPARQLAuth

opl:isDescribedUsing

n27:rdf

sioc:has_creator

n13:this n9:this

sioc:attachment

n21:png n22:png n23:png n24: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

n5:ODS

n12:has_services

n11:item

atom:title

OdsSPARQLAuth

sioc:links_to

n2:ODSAddressBookWebIDACL n7:rdfsupportedprotocolendpointuri n7:sparqwebservicetbl n2:ODSAddressBookWebIDACLPerson n8: n7:rdfsupportedprotocolendpoint n2:ODSCalendarWebIDACLPublic n10:VirtSetupSSL n2:ODSCalendarWebIDACLGroup n2:ODSBookmarksWebIDACLPerson n2:ODSBookmarksWebIDACL n2:CategoryODS n16: n17:ssl n18:php n2:ODSGenerateWebIDX509CertOSKeystore n2:OdsKeyImport n19:WebID n19:WebDAV n2:CategoryWebSite n2:ODSFeedManagerWebIDACLGroup n10:VirtSPARQLSecurityWebID n2:ODSFeedManagerWebIDACLPerson n10:VirtTipsAndTricksGuideSPARQLEndpoints n2:CategoryOpenSource n10:VirtTipsAndTricksGuide n10:VirtSPARQLDET n10:VirtSPARQLEndpointProtection n2:ODSCalendarWebIDACL n10:VirtOAuthSPARQL n2:ODSFeedManagerWebIDACLPublic n10:VirtSPARQLSSL n10:VirtAuthServerUI n2:ODSBriefcaseWebIDPerson n2:ODSGenerateX509Certificate n2:ODSBriefcaseWebID n2:ODSFeedManagerWebIDACL n10:VirtTipsAndTricksGuideSPARQLEndpointProtection n2:ODSBriefcaseWebIDPublic n2:ODSCalendarWebIDACLPerson n2:ODSGenerateWebIDX509CertBrsKeystore n2:ODSBookmarksWebIDACLPublic n2:ODSBriefcaseWebIDGroup n2:ODSBookmarksWebIDACLGroup n2:ODSAddressBookWebIDACLPublic n2:ODSAddressBookWebIDACLGroup n30:html

atom:source

n5:ODS

atom:author

n15:this

atom:published

2017-06-13T06:03:29Z

atom:updated

2017-06-29T07:32:28Z

sioc:topic

n5:ODS

Subject Item

n2:VirtODSSecurityWebID

sioc:links_to

n2:OdsSPARQLAuth

Subject Item

n2:ODSWebIDIdP

sioc:links_to

n2:OdsSPARQLAuth

Subject Item

n2:VirtODSPubSubHub

sioc:links_to

n2:OdsSPARQLAuth