Restricting users from some components in Apex 4.2 application

• Create Groups to differentiate users:

• Edit users and add them to Groups. If a user is Administrator than put it in Admin group.
• Go to Application builder  -> Application -> Shared Components -> Authorization Schemes and create a new Authorization Scheme.
• Select From Scratch
• In Authorization Scheme put following PL/SQL

• Go to the Application page that you want to prevent all users seeing (only Admin group)  and in Security choose the scheme you want:

How to reset Apex internal password with a script.

This is the script i use to reset Apex password in Apex version 4.x.

• Login to db as sysdba
• Check what verison is APEX user (mine case is 4.2 or APEX_040200)
• Execute Script

Script:

set define '&'

set verify off

alter session set current_schema = APEX_040200;

prompt ...changing password for ADMIN

begin

  wwv_flow_security.g_security_group_id := 10;

  wwv_flow_security.g_user := 'ADMIN';

  wwv_flow_security.g_import_in_progress := true;

  for c1 in (select user_id from wwv_flow_fnd_user

      where security_group_id = wwv_flow_security.g_security_group_id

      and user_name = wwv_flow_security.g_user) loop

     wwv_flow_fnd_user_api.edit_fnd_user(

       p_user_id => c1.user_id,

       p_user_name => wwv_flow_security.g_user,

       p_web_password => '&1',

       p_new_password => '&1');

  end loop;

  wwv_flow_security.g_import_in_progress := false;

end;

/

commit;

/

APEX Listener stop responding after some time

After some time or server restarts i tried to get APEX page live. After trying to access login page i got error:

"Requested url

http://apextest:7001/apex/f is currently unavailable."

I found that the problem is when APEX listener is started it created file named apex-config.xml in current TEMP file in Windows.

There are two solutions.

First one is to go to page :

http://wlstest:7001/apex/listenerconfigure and re-instantiating APEX listener.

Another solution is to follow Oracle manual for Apex listener and unzip apex.war, edit web.xml file so param-name config.dir is enabled, and enter any value (C:\apex_config\...). Zip everything and redeploy apex.war and restat apex web aplication (Weblogic server component).