User password encryption for COGNOS permission authentication cjp

During project development, users usually have clear requirements on system security. The following describes how to encrypt the user password for COGNOS portal authentication to provide a simple Wf

1cognos permission authentication method: cjp

2 Cognos user database type: Oracle

3. User Password Encryption: MD5

This article mainly describes the implementation process:

A: The MD5 encryption method can be implemented by writing Java code or writing in the database. In this example, the function Writing Method on the DB server is used to solve the MD5 encryption problem.

(1): For your convenience, add the MD5 encryption method source code.

CREATE OR REPLACE FUNCTION MD5(passwd IN VARCHAR2)RETURN VARCHAR2ISretval varchar2(32);v_pwd  varchar2(32);BEGIN       v_pwd:= NVL(passwd,‘123456‘);              retval := utl_raw.cast_to_raw(DBMS_OBFUSCATION_TOOLKIT.MD5(INPUT_STRING => v_pwd)) ;       RETURN retval;END;

(2) Test the method. After the password column is processed, it can be seen that all the passwords are encrypted, and you need to remember to log on when logging on, the administrator can reset the password.

--- MD5 method example

--- Encrypt all passwords

B: Modify the source code of the original verification package to verify whether the user is in the cjp user inventory. encrypt the package first and then match the password in the user library.

After the above operation, the user enters the plaintext password on the logon interface to log on, for example, 123456. In the authenticated Java program, the plaintext is encrypted and then matched.

Match OK to connect to the Cognos server and assign related permissions. This ensures the security of user information in the database.

 

PS: it should be explained that when Cognos is integrated with a third-party portal, you only need to encrypt and verify before considering Portal Login verification.

The encryption verification is handed over to the previously configured cjp encryption verification program. You do not need to encrypt the Cognos login again at the portal, as long as you have the operation to log on to Cognos.

The request is forwarded to the cjp user verification program to process the user's login to the Congo server.

User password encryption for COGNOS permission authentication cjp