Hi I don’t understand the problem you are describing, so can you please provide a test case that can be created locally ?
If I insert the following data via isql and query it I get the following: SQL> SPARQL Type the rest of statement, end with a semicolon (;)> insert into graph <http://BookStore.com> Type the rest of statement, end with a semicolon (;)> { Type the rest of statement, end with a semicolon (;)> <http://www.dajobe.org/foaf.rdf#i> <http://purl.org/dc/elements/1.1/date> <1999-04-01T00:00:00> . Type the rest of statement, end with a semicolon (;)> <http://www.w3.org/People/Berners-Lee/card#i> <http://purl.org/dc/elements/1.1/date> <1998-05-03T00:00:00> . Type the rest of statement, end with a semicolon (;)> <http://www.w3.org/People/Connolly/#me> <http://purl.org/dc/elements/1.1/date> <2001-02-08T00:00:00> Type the rest of statement, end with a semicolon (;)> }; callret-0 VARCHAR _______________________________________________________________________________ Insert into <http://BookStore.com>, 3 (or less) triples -- done 1 Rows. -- 600 msec. SQL> sparql select * from <http://BookStore.com> where {?s ?p ?o}; s p oVARCHAR VARCHAR VARCHAR _______________________________________________________________________________ http://www.dajobe.org/foaf.rdf#i http://purl.org/dc/elements/1.1/date 1999-04-01T00:00:00 http://www.w3.org/People/Berners-Lee/card#i http://purl.org/dc/elements/1.1/date 1998-05-03T00:00:00 http://www.w3.org/People/Connolly/#me http://purl.org/dc/elements/1.1/date 2001-02-08T00:00:00 3 Rows. -- 3 msec. SQL> and get the same output querying via the SPARQL endpoint: s p o http://www.dajobe.org/foaf.rdf#i http://purl.org/dc/elements/1.1/date 1999-04-01T00:00:00 http://www.w3.org/People/Berners-Lee/card#i http://purl.org/dc/elements/1.1/date 1998-05-03T00:00:00 http://www.w3.org/People/Connolly/#me http://purl.org/dc/elements/1.1/date 2001-02-08T00:00:00 Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 3 Aug 2011, at 18:15, Houda kr wrote: > OK thanks Hugh. > I have also another question : how can I remove the timezone added by > Virtuoso from the SPARQL results (queries executed on SPARQL endpoint) when > the datatype is dateTime. I want to simply have 00:00:00Tyyyy-mm-dd instead > of 00:00:00Tyyyy-mm-dd+01:00 (the +01:00 is added by Virtuoso). I don't have > the problem when I run the query using SQL interactive. > > Best, > Houda > > 2011/8/3 Hugh Williams <hwilli...@openlinksw.com> > Hi Houda, > > You are missing the following from the example in the documentation, which is > required before you can set user permissions on graphs: > -- At least some data are supposed to be confidential, > -- thus the whole storage becomes confidential. > DB.DBA.RDF_DEFAULT_USER_PERMS_SET ('nobody', 0); > > -- Moreover, no one of created users have access to all > -- graphs (even for reading). > DB.DBA.RDF_DEFAULT_USER_PERMS_SET ('Anna', 0); > > > The error message is rather misleading though, so will see about getting it > changed > > $ /opt/virtuoso/bin/isql opluswinbuild:1111 > Connected to OpenLink Virtuoso > Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver > OpenLink Interactive SQL (Virtuoso), version 0.9849b. > Type HELP; for help and EXIT; to exit. > SQL> DB.DBA.USER_CREATE ('Anna', 'Anna'); > > Done. -- 4285 msec. > SQL> DB.DBA.RDF_DEFAULT_USER_PERMS_SET ('Anna', 1); > > Done. -- 1201 msec. > SQL> DB.DBA.RDF_GRAPH_USER_PERMS_SET ('http://example.com', 'Anna', 3); > > *** Error RDF99: [Virtuoso Driver][Virtuoso Server]Permissions of > unauthenticated user are broader than new permissions of user "Anna" on > specific graph <http://example.com> > at line 3 of Top-Level: > DB.DBA.RDF_GRAPH_USER_PERMS_SET ('http://example.com', 'Anna', 3) > SQL> DB.DBA.RDF_DEFAULT_USER_PERMS_SET ('nobody', 0); > > Done. -- 386 msec. > SQL> DB.DBA.RDF_GRAPH_USER_PERMS_SET ('http://example.com', 'Anna', 3); > > Done. -- 251 msec. > SQL> > > > Best Regards > Hugh Williams > Professional Services > OpenLink Software > Web: http://www.openlinksw.com > Support: http://support.openlinksw.com > Forums: http://boards.openlinksw.com/support > Twitter: http://twitter.com/OpenLink > > On 3 Aug 2011, at 10:36, Houda kr wrote: > >> Hi, >> >> I am trying to create a new user (Anna) in Virtuoso and specify his >> permission (read/write) on a specific graph <http://example.com> and only >> read for the rest of graphs. I follow the example provided in this link >> http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFGraphsSecurity, >> and I execute the following commands : >> DB.DBA.USER_CREATE ('Anna', 'Anna'); >> DB.DBA.RDF_DEFAULT_USER_PERMS_SET ('Anna', 1); >> DB.DBA.RDF_GRAPH_USER_PERMS_SET ('http://example.com', 'Anna', 3); >> >> >> >> But, the last command generates the following error : >> >> *** Error RDF99: [Virtuoso Driver][Virtuoso Server]Permissions of >> unauthenticated user are broader than new permissions of user "Anna" on >> specific graph <http://example.com> >> >> Is there something wrong ? >> >> Thanks >> Houda >> >> >> ------------------------------------------------------------------------------ >> BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA >> The must-attend event for mobile developers. Connect with experts. >> Get tools for creating Super Apps. See the latest technologies. >> Sessions, hands-on labs, demos & much more. Register early & save! >> http://p.sf.net/sfu/rim-blackberry-1_______________________________________________ >> Virtuoso-users mailing list >> Virtuoso-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > > ------------------------------------------------------------------------------ > BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA > The must-attend event for mobile developers. Connect with experts. > Get tools for creating Super Apps. See the latest technologies. > Sessions, hands-on labs, demos & much more. Register early & save! > http://p.sf.net/sfu/rim-blackberry-1_______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
