[vhffs-dev] [1033] Add missing ACLs on users objects

[subversion@xxxxxxxxxxxxx]

Revision: 1033
Author:   gradator
Date:     2007-10-26 19:54:30 +0000 (Fri, 26 Oct 2007)

Log Message:
-----------
Add missing ACLs on users objects

Modified Paths:
--------------
    trunk/vhffs-compat/4.0.sql.in


Modified: trunk/vhffs-compat/4.0.sql.in
===================================================================
--- trunk/vhffs-compat/4.0.sql.in	2007-10-26 19:39:45 UTC (rev 1032)
+++ trunk/vhffs-compat/4.0.sql.in	2007-10-26 19:54:30 UTC (rev 1033)
@@ -387,3 +387,7 @@
 ALTER TABLE vhffs_boxes ADD COLUMN state int4;
 UPDATE vhffs_boxes SET state=6;
 ALTER TABLE vhffs_boxes ALTER state SET NOT NULL;
+
+-- add ACLs on users
+INSERT INTO vhffs_acl( granted_oid,target_oid,perm ) ( SELECT object_id,object_id,12 FROM vhffs_users );
+INSERT INTO vhffs_acl( granted_oid,target_oid,perm ) ( SELECT g.object_id,u.object_id,0 FROM vhffs_users u INNER JOIN vhffs_groups g ON u.gid=g.gid );