Query to find database password for login credential in Oracle Applications

Query to find database password for login credential in Oracle Applications



/*<SQL_FILE_CHUNK>*/
CREATE OR REPLACE PACKAGE apps.get_pwd
AS
   FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
      RETURN VARCHAR2;
END get_pwd;
/
/*<TOAD_FILE_CHUNK>*/

--------------------------------------------------------------------------

CREATE OR REPLACE PACKAGE BODY apps.get_pwd
AS
   FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
      RETURN VARCHAR2
   AS
      LANGUAGE JAVA
      NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';
END get_pwd;
/
/*<SQL_FILE_CHUNK>*/
--------------------------------------------------------------------------


SELECT usertable.user_name
, (SELECT get_pwd.decrypt (UPPER ((SELECT (SELECT get_pwd.decrypt (UPPER
((SELECT UPPER (fnd_profile.VALUE ('GUEST_USER_PWD'))
FROM DUAL)), usertable.encrypted_foundation_password)
FROM DUAL) AS apps_password
FROM fnd_user usertable
WHERE usertable.user_name LIKE
UPPER ((SELECT SUBSTR (fnd_profile.VALUE ('GUEST_USER_PWD')
,1
, INSTR (fnd_profile.VALUE ('GUEST_USER_PWD'), '/')
- 1
)
FROM DUAL))))
,usertable.encrypted_user_password)
FROM DUAL) AS encrypted_user_password
FROM apps.fnd_user usertable
WHERE usertable.user_name LIKE UPPER ('fin_tech_user');

 

Steps for Disabling protected View in Excel for outlook excel file attachment

Steps for Disabling protected View in Excel

The outlook mail along with excel or csv file would need to open in Outlook or mobile outlook need to disable the settings as below

Steps for Disabling Protected View:

1.      Open the outlook mail. Save the excel file to desktop. Right click on the file à Save As. Kindly note this is only one time step. User need not do it every time once the setups are complete.

2.      Open the file from Desktop. we will get a blank screen as it is protected file

3.      Click on file in excel -> click on options -> Trust Center -> Click on Trust Center settings -> Click on protected view

4.      3 options are enabled -> Uncheck all the 3 check boxes

5.      Click on Ok and on next screen click on OK too

6.      Close the excel. If it asks for saving, save the file.

7.      Open the file again,

8.      We will get the message to be proceed or not.

9.      Click Yes.

10.  The output will be displayed