Question: I would like to be able to programmatically identify the field level
security profile that is applied to the current record in SalesLogix. Is it possible to do this?
Answer: This should help you:
SELECT A.*, S.PROFILEDESCRIPTION
FROM ACCOUNT A
INNER JOIN SECRIGHTS SR
ON A.SECCODEID = SR.SECCODEID
AND SR.ACCESSID = ‘UDEMOA00000I’
INNER JOIN SECPROFILE S
ON SR.PROFILEID = S.PROFILEID



