Hi Núria,
The commands you have executed have not been against the procedure name giving
the error ie DB.DBA.SPARQL_INSERT_QUAD_DICT_CONTENT and you are executing
against SPARQL_INSERT_DICT_CONTENT and SPARQL_DELETE_DICT_CONTENT ???
Based on the procedure name giving the error reported you should be running
the commands:
grant execute on DB.DBA.SPARQL_INSERT_QUAD_DICT_CONTENT to "SPARQL"
grant execute on DB.DBA.SPARQL_INSERT_QUAD_DICT_CONTENT to SPARQL_UPDATE
to get around this ...
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 14 Jan 2014, at 10:05, "QUERALT ROSINACH, NÚRIA" <nuria.quer...@upf.edu>
wrote:
> Dear all,
>
> I am trying to insert data into named graphs using statements like in a
> Virtuoso server v7.0.1:
>
> INSERT
> {
> GRAPH <
> http://example.org
> >
> {
> ?person <
> http://xmlns.com/foaf/0.1/name
> > ?name .
> ?person <
> http://xmlns.com/foaf/0.1/mbox
> > ?email
> }
> }
>
>
> And the following error come up:
>
> Virtuoso 42000 Error SR186: No permission to execute procedure
> DB.DBA.SPARQL_INSERT_QUAD_DICT_CONTENT with user ID 106, group ID 106
>
> Then i grant "SPARQL" user with the following commands via the isql shell:
>
>
> grant execute on DB.DBA.SPARQL_INSERT_DICT_CONTENT to "SPARQL";
> grant execute on DB.DBA.SPARQL_DELETE_DICT_CONTENT to "SPARQL";
>
>
> But i've obtained the same error...Could you help me in this issue? Many
> thanks in advance!
>
> Best regards,
> Núria
>
>
>
>
>
> --
> ********************************************************************
> Núria Queralt Rosinach
> Research Programme on Biomedical Informatics (GRIB)
> Department of Experimental and Health Sciences
> Universitat Pompeu Fabra
> IMIM (Hospital del Mar Medical Research Institute)
> C/Dr. Aiguader 88, 08003
> Barcelona, Spain
> Tel.: +34 93 316 0536
> E-mail: nuria.quer...@upf.edu
> http://ibi.imim.es/
> ********************************************************************
>
> ------------------------------------------------------------------------------
> CenturyLink Cloud: The Leader in Enterprise Cloud Services.
> Learn Why More Businesses Are Choosing CenturyLink Cloud For
> Critical Workloads, Development Environments & Everything In Between.
> Get a Quote or Start a Free Trial Today.
> http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In Between.
Get a Quote or Start a Free Trial Today.
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
