Hi,
I'd certainly suggest disabling Update permission on the Sparql user for
the reasons you mention.
You can then make a second user for the purpose of authorised
transactions and use this against the /sparql-auth endpoint which you'll
need to enable and configure. I believe that will do what you want.
This will give you some hints but you'll need to do a little more
research to get sparql-auth set up. I believe it's available in the
open-source version though it's been a while since I used it.
https://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksDigestAuthAJAX
--
Regards,
Quentin Serrurier.
GuidingHand.Solutions
On 2017-04-04 21:54, Iker Esnaola wrote:
> Hello,
>
> I am trying to update my Graph by means of the SPARQL endpoint and the
> following query:
>
> DELETE {?s rdf:type "A "}
>
> INSERT {?s rdf:type "B" }
>
> from <myGRAPH>
>
> WHERE { ?s rdf:type "A"}
>
> I am getting the following error: Virtuoso 42000 Error SR186:SECURITY: No
> permission to execute procedure DB.DBA.SPARQL_MODIFY_BY_DICT_CONTENTS with
> user ID 107, group ID 107
>
> After giving SPARQL_UPDATE permissions to the "SPARQL" user, there is no such
> a problem and I am able to perform the query.
>
> However, my SPARQL endpoint is public so this is not a good practice.
>
> I have been looking for information in this matter but I didn't find anything
> decisive. Is there any possibility of login in the SPARQL endpoint? I am
> thinking of some way of enabling certain users to update the content (e.g.
> administrators) while leaving the rest of the users with only query
> permissions.
>
> Thanks in advance,
>
> IKER ESNAOLA GONZALEZ
>
> Informazio-Sistema Adimenduen Unitatea
>
> Sistemas de Información Inteligentes
>
> Intelligent Information Systems Unit
>
> iker.esna...@tekniker.es
>
> +34 943 20 67 44 Ext: 9608
>
> PARKE TEKNOLOGIKOA
>
> C/ Iñaki Goenaga, 5
>
> 20600 Eibar, Gipuzkoa (Spain)
>
> Tel.: +34 943 20 67 44
>
> [3] [4] [5] [6] [7]
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot [1]
>
> _______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users [2]
Links:
------
[1] http://sdm.link/slashdot
[2] https://lists.sourceforge.net/lists/listinfo/virtuoso-users
[3] https://www.youtube.com/user/Teknikertv
[4] https://twitter.com/ik4_tekniker
[5] https://www.flickr.com/people/teknikerik4/
[6] http://es.slideshare.net/teknikerik4
[7] http://issuu.com/ik4-tekniker
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
