davical-9da21ad116a2913bf788bd4b0b8c58c0de83d9da/dba/better_perms.sql

7   IF in_priv ~* 'A' THEN
10   END IF;
16   IF in_priv ~* 'R' THEN
18   END IF;
25   IF in_priv ~* 'W' THEN
27   END IF;
30   IF in_priv ~* 'B' THEN
32   END IF;
35   IF in_priv ~* 'U' THEN
37   END IF;
41   IF in_priv ~* 'F' THEN
43   END IF;
63   IF in_bits = (~ 0::BIT(24)) THEN
66   END IF;
72   IF (in_bits & 4609::BIT(24)) != 0::BIT(24) THEN
73     IF (in_bits & 1::BIT(24)) != 0::BIT(24) THEN
77     END IF;
78   END IF;
85   IF (in_bits & 198::BIT(24)) != 0::BIT(24) THEN
86     IF (in_bits & 6::BIT(24)) != 0::BIT(24) THEN
89       IF (in_bits & 64::BIT(24)) != 0::BIT(24) THEN
91       END IF;
92       IF (in_bits & 128::BIT(24)) != 0::BIT(24) THEN
94       END IF;
95     END IF;
96   END IF;
116   IF in_from = in_to THEN
118   END IF;
123   IF FOUND THEN
125   END IF;
133   IF bit_confers != 0::BIT(24) THEN
135   END IF;
144   IF FOUND THEN
148   END IF;
170   IF in_from = in_to THEN
172   END IF;
177   IF EXISTS(SELECT 1 FROM relationship WHERE from_user = in_from AND to_user = in_to
183   END IF;
185   IF EXISTS( SELECT 1 FROM relationship r1 JOIN relationship r2 ON r1.to_user=r2.from_user
192   END IF;
194   IF EXISTS( SELECT 1 FROM relationship r1 JOIN relationship r2 ON r1.to_user=r2.to_user
202   END IF;
218   IF in_priv = 'all' THEN
220   END IF;
265     IF out_bits = all THEN
267     END IF;
288   IF in_bits = (~ 0::BIT(24)) THEN
290   END IF;
292   IF (in_bits & 513::BIT(24)) != 0::BIT(24) THEN
293     IF (in_bits & 1::BIT(24)) != 0::BIT(24) THEN
295     END IF;
296     IF (in_bits & 512::BIT(24)) != 0::BIT(24) THEN
298     END IF;
299   END IF;
301   IF (in_bits & 198::BIT(24)) != 0::BIT(24) THEN
302     IF (in_bits & 198::BIT(24)) = 198::BIT(24) THEN
305       IF (in_bits & 2::BIT(24)) != 0::BIT(24) THEN
307       END IF;
308       IF (in_bits & 4::BIT(24)) != 0::BIT(24) THEN
310       END IF;
311       IF (in_bits & 64::BIT(24)) != 0::BIT(24) THEN
313       END IF;
314       IF (in_bits & 128::BIT(24)) != 0::BIT(24) THEN
316       END IF;
317     END IF;
318   END IF;
320   IF (in_bits & 8::BIT(24)) != 0::BIT(24) THEN
322   END IF;
324   IF (in_bits & 16::BIT(24)) != 0::BIT(24) THEN
326   END IF;
328   IF (in_bits & 32::BIT(24)) != 0::BIT(24) THEN
330   END IF;
332   IF (in_bits & 256::BIT(24)) != 0::BIT(24) THEN
334   END IF;
336   IF (in_bits & 7168::BIT(24)) != 0::BIT(24) THEN
337     IF (in_bits & 7168::BIT(24)) = 7168::BIT(24) THEN
340       IF (in_bits & 1024::BIT(24)) != 0::BIT(24) THEN
342       END IF;
343       IF (in_bits & 2048::BIT(24)) != 0::BIT(24) THEN
345       END IF;
346       IF (in_bits & 4096::BIT(24)) != 0::BIT(24) THEN
348       END IF;
349     END IF;
350   END IF;
352   IF (in_bits & 57344::BIT(24)) != 0::BIT(24) THEN
353     IF (in_bits & 57344::BIT(24)) = 57344::BIT(24) THEN
356       IF (in_bits & 8192::BIT(24)) != 0::BIT(24) THEN
358       END IF;
359       IF (in_bits & 16384::BIT(24)) != 0::BIT(24) THEN
361       END IF;
362       IF (in_bits & 32768::BIT(24)) != 0::BIT(24) THEN
364       END IF;
365     END IF;
366   END IF;