metacat/test/test-queries/access.sql @ 5949
| 1 |
SELECT docid from xml_access |
|---|---|
| 2 |
WHERE
|
| 3 |
(
|
| 4 |
(lower(principal_name) = 'public' |
| 5 |
AND perm_type = 'allow' |
| 6 |
AND (permission='4' OR permission='7') |
| 7 |
)
|
| 8 |
OR
|
| 9 |
(lower(principal_name) = 'public' |
| 10 |
AND perm_type = 'allow' |
| 11 |
AND (permission='4' OR permission='7') |
| 12 |
)
|
| 13 |
)
|
| 14 |
/
|