APEX

Hi. i need to copy the users from an apex to another.

@apex4 is a DBlink to the original apex 4 installation, i need to create the users on a new apex4 server, where i'm loged and execute this script:


declare
cursor users is
select *
from apex_040100.wwv_flow_fnd_user@apex4
where user_name<>'ADMIN';
begin
for u in users loop
APEX_UTIL .create_user(
p_user_id => u.user_id,
p_user_name => u.user_name,
p_first_name => u.first_name,
p_last_name => u.last_name,
p_description => u.description,
p_email_address => u.email_address,
p_web_password => '1234',
p_web_password_format => 'CLEAR_TEXT');
end loop;
end;

i'm tried login with apex_public_user, and sys as sysadmin, but I always get the same error:

ORA-20987: APEX - Unauthorized access (security group package variable not set). - Contact your application administrator.
ORA-06512: en "APEX_040100.WWV_FLOW_ERROR", línea 704
ORA-06512: en "APEX_040100.WWV_FLOW_ERROR", línea 1008
ORA-06512: en "APEX_040100.WWV_FLOW_FND_USER_API", línea 24
ORA-06512: en "APEX_040100.WWV_FLOW_FND_USER_API", línea 617
ORA-06512: en "APEX_040100.HTMLDB_UTIL", línea 1395
ORA-06512: en línea 8

Thanks in advance, and sorry for my English.

Edited by: Andres Vilallave on 31-ene-2012 12:48

Edited by: Andres Vilallave on 31-ene-2012 12:49