| [vhffs-dev] [985] this is better to discard groups associated to users, ACL are not needed on them |
[ Thread Index |
Date Index
| More vhffs.org/vhffs-dev Archives
]
Revision: 985
Author: gradator
Date: 2007-10-14 15:39:05 +0000 (Sun, 14 Oct 2007)
Log Message:
-----------
this is better to discard groups associated to users, ACL are not needed on them
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-14 15:31:37 UTC (rev 984)
+++ trunk/vhffs-compat/4.0.sql.in 2007-10-14 15:39:05 UTC (rev 985)
@@ -374,4 +374,4 @@
) WITH OIDS;
-- add ACLs on group to group
-INSERT INTO vhffs_acl( granted_oid,target_oid,perm ) ( SELECT object_id,object_id,2 FROM vhffs_groups );
+INSERT INTO vhffs_acl( granted_oid,target_oid,perm ) ( SELECT object_id,object_id,2 FROM vhffs_groups WHERE gid NOT IN (SELECT gid FROM vhffs_users) );