Forum OpenACS Q&A: Re: Retrieve object_id of System Owner?

Collapse
3: Re: Retrieve object_id of System Owner? (response to 1)
Posted by Peter Marklund on 08/29/03 05:34 PM
I like the min() approach. Here is what I would do:

set context_root_id [db_string select_context_root_id {
    select acs.magic_object_id('default_context') from dual
}]

set admin_user_id [db_string select_admin_user_id {
    select min(user_id)
    from users
    where acs_permission.permission_p(:context_root_id, user_id, 'admin') = 't'
}]

Collapse
4: Re: Retrieve object_id of System Owner? (response to 3)
Posted by Jeff Davis on 08/29/03 05:59 PM
I would argue for making the "system owner" an entry
in acs_magic_objects, but if that seems appalling and you
prefer Peter's method you should probably do it with a
join to the permission view rather than with the permission_p
function (which will force a table scan on users).