Tuesday, July 31, 2012

WebProfile Tables (8.46)

These are the tables behind WebProfile Settings

SELECT * FROM PSWEBPROFILE
SELECT * FROM PSWEBPROFBROW
SELECT * FROM PSWEBPROFCOOK
SELECT * FROM PSWEBPROFDEF
SELECT * FROM PSWEBPROFHIST
SELECT * FROM PSWEBPROFNVP
SELECT * FROM PSWEBPROFPROP
 
PSWEBPROFNVP  stores Virtual Address(Load Balancer), XMLLINK userid and password, public access userid and password etc. These tables can save your life if you have messed up your web profile settings and cannot login through web