sql

SIEBEL: Finding Encryption Key for User in Siebel


To find Encryption Key in Siebel to connect local database you can use below query providing USER ID. SELECT PREF_CD, VAL FROM SIEBEL.S_NODE_PREF s1, SIEBEL.S_NODE s2 WHERE s1.PREF_CD =’RemLocSec:PlainKey’ AND s1.NODE_ID = s2.ROW_ID AND s2.NAME =’USER ID’ Advertisements