Hi Lorena,
Which Virtuoso 7.10 build are you using as this works of me testing with isql
or the /sparql-auth endpoint using the git Virtuoso open source develop/7
branch built as detailed at:
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSGitUsage
$ isql 1234
Connected to OpenLink Virtuoso
Driver: 07.10.3211 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL> DB.DBA.USER_CREATE ('student', 'student');
Done. -- 19 msec.
SQL> GRANT SPARQL_UPDATE TO "student";
Done. -- 2 msec.
SQL> quit;
[root@masala vos]# isql 1234 student student
Connected to OpenLink Virtuoso
Driver: 07.10.3211 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit
SQL> SPARQL INSERT DATA { GRAPH <http://example.org/graph> {
<http://edf.org/resource/dev> foaf:name "dev" . }};
Done. -- 1 msec.
SQL> SPARQL SELECT * FROM <http://example.org/graph> WHERE {?s ?p ?o};
s
p
o
VARCHAR
VARCHAR
VARCHAR
_______________________________________________________________________________
http://edf.org/resource/dev
http://xmlns.com/foaf/0.1/name
dev
1 Rows. -- 1 msec.
SQL> status('');
REPORT
VARCHAR
_______________________________________________________________________________
OpenLink Virtuoso Server
Version 07.10.3211-pthreads for Linux as of Jul 12 2014
Started on: 2014-08-31 16:42 GMT+2
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
On 28 Aug 2014, at 16:01, lorena <lore...@gmail.com> wrote:
> Hi
>
> I'm using Virtuoso 07.10 and I would like to give a minimum set of
> permissions to a user in order to be able to insert data into a graph
> and perform SPARQL queries over it.
>
> I've created a new user using the following isql commands
>
> DB.DBA.USER_CREATE ('student', 'student');
> GRANT SPARQL_UPDATE TO "student";
>
> Then, I log in with the "student" user into my endpoint using sparql-auth.
> Performing this simple SPARQL 1.1 insert returns the following error message
>
> INSERT DATA
> {
> GRAPH <http://example.org/graph> { <http://edf.org/resource/dev>
> foaf:name "dev" . }
> }
>
> Virtuoso RDF02 Error SR619: SPARUL INSERT access denied: database user
> 111 (curso) has no write permission on graph http://example.org/graph
>
> SPARQL query:
> define sql:big-data-const 0
> #output-format:text/html
> define sql:signal-void-variables 1 INSERT DATA
> {
> GRAPH <http://example.org/graph> { <http://edf.org/resource/dev>
> foaf:name "dev" . }
> }
>
> By using the older Virtuoso syntax for updates I obtain the same error message
>
> INSERT IN GRAPH <http://example.org/graph> {
> <http://edf.org/resource/dev> foaf:name "dev" . }
>
> These two examples work fine if I log in with the dba user.
> What I'm missing?
>
> regards
> Lorena
>
> ------------------------------------------------------------------------------
> Slashdot TV.
> Video for Nerds. Stuff that matters.
> http://tv.slashdot.org/
> _______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Slashdot TV.
Video for Nerds. Stuff that matters.
http://tv.slashdot.org/
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
