Hi Julien, What is the query you are executing and via what interface are you executing it ? Perhaps you also need to add the grant on the table the view is created from also, if not already done ?
Please use the “trace_on()” function (http://docs.openlinksw.com/virtuoso/fn_trace_on.html) to enable additional server side tracing and provide the output leading to the error which may provide additional information as to the possible cause ... 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 25 Jun 2012, at 17:24, Julien Plu wrote: > Hi, > > I made a R2RML mapping and I use a SQL view in this mapping that I created. > So when I try to query the result of this mapping I fall on this error : > > Virtuoso 42000 Error SQ200: Must have select privileges on view > musicbrainz_db.musicbrainz.musicbrainz_view > Even if I do : > > GRANT SELECT ON musicbrainz_db.musicbrainz.musicbrainz_view TO "SPARQL", > "SPARQL_UPDATE" > > Have-you an idea for why this error occur ? > > Thanks in advance. > > Best. > > ------------------------------------------------------------------------------------------------------------------------------- > Julien Plu > > Etudiant en 2ème année de Master Ingénierie en Intelligence Artificielle à > l'université Montpellier 2. > Responsable de la rubrique Web sémantique de Developpez.com. > Mes projets Web sémantique: http://data.lirmm.fr > Page personnelle: http://jplu.developpez.com > Fichier FOAF (version RDF): http://jplu.developpez.com/julien > Fichier FOAF (version RDFa): http://jplu.developpez.com/julien.html > Adresse mail personnelle: [email protected] > Adresse mail universitaire: [email protected] > > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. > http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/_______________________________________________ > Virtuoso-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
