Skip to content

@xaprb /all-acl-entries.php
Created

Embed URL

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
<?php
$permissions = array(
"owner_read" => 256,
"owner_write" => 128,
"owner_delete" => 64,
"group_read" => 32,
"group_write" => 16,
"group_delete" => 8,
"other_read" => 4,
"other_write" => 2,
"other_delete" => 1
);
$groups = array(
"root" => 1,
"officer" => 2,
"user" => 4,
"wheel" => 8
);
$obj_id = 2;
$tbl = 't_user';
$user_id = 2;
$user_groups = 4;
$query = "
select
pr.c_role,
pr.c_who,
case
when (pr.c_role = 'user') then coalesce(us.c_username, '--DNE--')
when (pr.c_role = 'group') then ''
when (pr.c_role = 'owner_group') then ''
else 'none'
end as c_name,
pr.c_action,
pr.c_type,
pr.c_related_table as c_table,
pr.c_related_uid,
ia.c_status
from t_privilege as pr
inner join t_action as ac on ac.c_title = pr.c_action
inner join $tbl as ob on ob.c_uid = $obj_id
inner join t_implemented_action as ia on ia.c_table = '$tbl'
and ia.c_action = ac.c_title
left outer join t_user as us
on pr.c_role = 'user'
and pr.c_who = us.c_uid
where (
(pr.c_type = 'object' and pr.c_related_uid = $obj_id)
or (pr.c_type in ('table', 'global'))
or (pr.c_role = 'self' and pr.c_related_table = 't_user'))
and pr.c_related_table = '$tbl'
";
echo $query;
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.