Index: openacs-4/packages/assessment/tcl/as-apm-action-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/tcl/as-apm-action-procs-oracle.xql,v diff -u -r1.3 -r1.3.16.1 --- openacs-4/packages/assessment/tcl/as-apm-action-procs-oracle.xql 13 Mar 2005 22:08:45 -0000 1.3 +++ openacs-4/packages/assessment/tcl/as-apm-action-procs-oracle.xql 1 Sep 2020 15:11:19 -0000 1.3.16.1 @@ -3,14 +3,6 @@ oracle8.1.6 - - - select q.user_id from - (select user_id - from users - where acs_permission.permission_p(:context_root_id, user_id, 'admin') = 't') q where rownum = 1 - - begin Index: openacs-4/packages/assessment/tcl/as-apm-action-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/tcl/as-apm-action-procs-postgresql.xql,v diff -u -r1.5 -r1.5.16.1 --- openacs-4/packages/assessment/tcl/as-apm-action-procs-postgresql.xql 13 Mar 2005 22:08:45 -0000 1.5 +++ openacs-4/packages/assessment/tcl/as-apm-action-procs-postgresql.xql 1 Sep 2020 15:11:19 -0000 1.5.16.1 @@ -3,16 +3,6 @@ postgresql7.2 - - - - select user_id - from users - where acs_permission__permission_p(:context_root_id, user_id, 'admin') = 't' - limit 1 - - - select as_action__default_actions ($package_id,$user_id,$package_id) Index: openacs-4/packages/assessment/tcl/as-apm-action-procs.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/tcl/as-apm-action-procs.tcl,v diff -u -r1.10 -r1.10.2.1 --- openacs-4/packages/assessment/tcl/as-apm-action-procs.tcl 25 Apr 2018 21:32:06 -0000 1.10 +++ openacs-4/packages/assessment/tcl/as-apm-action-procs.tcl 1 Sep 2020 15:11:19 -0000 1.10.2.1 @@ -11,7 +11,11 @@ } { set context_root_id [acs_lookup_magic_object security_context_root] - return [db_string select_user_id {}] + return [db_string select_user_id { + select min(user_id) + from users + where acs_permission.permission_p(:context_root_id, user_id, 'admin') + }] } ad_proc -public as::actions::insert_actions {