Merge branch 'master' of github.com:DAViCal/davical into github
[davical.git] / testing / tests / regression-suite / 0945-ACL.test
blobafc4dd111df933cc7590e3e88d53143dcd526000
2 # ACL setting default privileges on a collection to nothing, and
3 #     specific privileges to include read-acl.
5 TYPE=ACL
6 URL=http://regression.host/caldav.php/user1/
7 HEADER=User-Agent: RFC3744 Spec Tests
8 HEADER=Content-Type: text/xml; charset="UTF-8"
9 HEAD
12 BEGINDATA
13 <?xml version="1.0" encoding="utf-8" ?>
14 <acl xmlns="DAV:" xmlns:CalDAV="urn:ietf:params:xml:ns:caldav">
15   <ace>
16     <principal>
17       <property><owner/></property>
18     </principal>
19     <grant>
20       <privilege><all/></privilege>
21     </grant>
22   </ace>
23   <ace>
24     <principal>
25       <href>/caldav.php/user4/</href>
26     </principal>
27     <grant>
28       <privilege><read/></privilege>
29       <privilege><read-acl/></privilege>
30       <privilege><read-current-user-privilege-set/></privilege>
31       <privilege><CalDAV:read-free-busy/></privilege>
32       <privilege><CalDAV:schedule-deliver/></privilege>
33       <privilege><CalDAV:schedule-send/></privilege>
34       <privilege><write/></privilege>
35       <privilege><bind/></privilege>
36       <privilege><unbind/></privilege>
37       <privilege><unlock/></privilege>
38     </grant>
39   </ace>
40   <ace>
41     <principal><authenticated/></principal>
42     <grant>
43       <privilege/>
44     </grant>
45   </ace>
46 </acl>
47 ENDDATA
49 QUERY
50 SELECT by_principal, by_collection, privileges, p_to.displayname, to_principal
51    FROM grants JOIN dav_principal p_to ON (to_principal=principal_id)
52           LEFT JOIN collection ON (by_collection=collection.collection_id)
53           LEFT JOIN dav_principal p_by ON (by_principal=p_by.principal_id)
54   WHERE p_by.username = 'user1'
55   ORDER BY by_principal, to_principal
56 ENDQUERY