Home » Uncategories » Oracle Apex 18.2 How to Display Logo on Login Screen Updated FREE

Oracle Apex 18.2 How to Display Logo on Login Screen Updated FREE

Oracle Apex 18.2 How to Display Logo on Login Screen

This post volition explain you about, how to capture use login, logout and session out fourth dimension in Oracle Noon applications using security attributes.

User Log Reports provides the detailed information well-nigh the users' login details along with their history. These reports are more accurate and likewise provides the details of the user, their logon time, logoff fourth dimension, the computer from which they logged on, the domain controller they reported, etc., along with their logon history. It also provides the details of Currently Logged On Users and Frequently Logged-on Users.

The following information can exist captured in the Database.

i. Login Date

2. Login Time

3. Session Id

iv. Organisation IP Address

five. Host Name

6. User Name

Step ane: Table Cosmos.

Pace 2: Creation of Page Subconscious Items.

Create Page Subconscious Items P0_SESSION_ID, P0_USER_ID for getting Session id equally well every bit User id.

Step 3: Creation of Insertion Process in the User Login Folio.

On Click of Login Button or Enter Push in Login Page the following process has to be created.

Insertion Process:

DECLARE

ln_session_id NUMBER;

lv_ip_address VARCHAR2 (30);

lv_login_date VARCHAR2 (100);

lv_login_time VARCHAR2 (50);

lv_user_role VARCHAR2 (l);

lv_current_schema VARCHAR2 (l);

lv_host VARCHAR2 (50);

BEGIN

-- Select Session id,Login Engagement,Login Time, Ip Address, Host name and Current Schema

Begin

SELECT 5 ('session'),

TO_CHAR (SYSDATE, 'dd-Mon-yyyy'),

TO_CHAR (SYSDATE, 'hh12:mi:ss PM'),

sys_context ('USERENV', 'IP_ADDRESS'),

sys_context ('USERENV', 'HOST'),

sys_context ('USERENV', 'CURRENT_SCHEMA'),

INTO ln_session_id,

lv_login_date,

lv_login_time,

lv_ip_address,

lv_host,

lv_current_schema

FROM dual;

EXCEPTION

WHEN OTHERS THEN

raise_application_error (-20001, 'Mistake on Selecting Session Id' || sqlerrm );

END;

-- Select the User Role

BEGIN

SELECT user_role

INTO lv_user_role

FROM homes_fnd_users

WHERE user_id = :p0_user_id;

EXCEPTION

WHEN OTHERS THEN

raise_application_error (-2007, 'Error on Selecting User Proper name' || sqlerrm );

Cease;

-- Insert Data to Corresponding Table

BEGIN

INSERT

INTO homes_inv_user_log_details

(

session_id,

user_role,

user_name,

CURRENT_SCHEMA,

host,

log_id,

login_date,

login_time,

ip_address

)

VALUES

(

ln_session_id,

lv_user_role,

:p0_user_id,

lv_current_schema,

lv_host,

homes_log_details.nextval,

lv_login_date,

lv_login_time,

lv_ip_address

);

EXCEPTION

WHEN OTHERS Then

raise_application_error (-20006, 'Fault on While Inserting records' || sqlerrm );

END;

End;

Step iv: Interactive Report Cosmos. Create a new page with Interactive Report that shows all the Login Details.

Output:

Department ii:

To Capture User Logout Details:

The following information will be captured in the Database.

one. Logout Date

ii. Logout Time

3. Session Id

4. System IP Address

5. Host Proper name

6. User Proper noun

Step 1: Creation of New Image.

Upload designed or downloaded images to Apex Workspace.

Step two: Push Creation

In Edit Folio remove Navigation Bar Entry Label, instead create a new Push in the Global Page (Zeroth Page) in your Apex Application.

1. At present create a new Region (Template=> No Template & Display Signal => Folio Template Region Position eight)

2. Create new Buttons (which is used in application) in this Region only. This Push will be displayed throughout the application.

3. Change the button way => Images.

4. Call the image from Apex Workspace,

#WORKSPACE_IMAGES#<<workspaceimage_name>>

Region Creation:

Navigation Bar Logout:

Set Navigation Bar Logout Condition every bit NEVER.

Pace 3: Creation of Dynamic Activeness

Since it is not possible to create a Procedure in Global Page, so create a dynamic activeness.

1. Execute PLSQL Code:

Create the following action On Click of Logout Push button.

DECLARE

lv_logout_date VARCHAR2 (100);

lv_logout_time VARCHAR2 (100);

BEGIN

-- Select Logout Engagement and Logout Time

BEGIN

SELECT to_char (SYSDATE, 'dd-Mon-yyyy'),

to_char (SYSDATE, 'hh12:mi:ss PM')

INTO lv_logout_date,

lv_logout_time

FROM dual;

exception

WHEN others THEN

raise_application_error (-20001, 'Mistake on Selecting Logout Appointment & Time' || sqlerrm );

End;

--Update Logout Date and Logout Time

Begin

UPDATE homes_inv_user_log_details

SET logout_date = lv_logout_date,

logout_time = lv_logout_time

WHERE session_id = :p0_session_id;

exception

WHEN others THEN

raise_application_error (-20003, 'Error on Updating Records' || sqlerrm );

END;

End;

2. Execute Coffee script Code:

window.location='&LOGOUT_URL.'

Stride 4: Create a new page with Interactive Report that shows all the Login Details.

Output:

Department 3:

Session Out Time Capture:

Paste the below code into SECURITY ATTRIBUTES = > DATABASE SESSION.

Execute PLSQL Lawmaking:

BEGIN

--Select Session Out Date & Session Out Time

Begin

SELECT TO_CHAR (SYSDATE, 'dd-Mon-yyyy'),

TO_CHAR (SYSDATE, 'hh12:mi:ss PM')

INTO lv_session_date,

lv_session_time

FROM dual;

EXCEPTION

WHEN OTHERS THEN

raise_application_error (-20001, 'Mistake on Selecting Logout Date' || sqlerrm );

END;

-- Update Session Out Appointment & Session Out Time When Session is Out

Brainstorm

UPDATE homes_inv_user_log_details

Gear up session_date = lv_session_date,

session_time = lv_session_time

WHERE session_id = :p0_session_id;

EXCEPTION

WHEN OTHERS So

raise_application_error (-20003, 'Fault on Updating Records' || sqlerrm );

END;

Output: