Security Profiles and Inheritance

[MikeSpragg]

Hi!

Anyone have a generic routine that will find (for an acc/con/opp) what the current users' security profile is?

For example, if I'm looking at an opportunity that is owned by Team A and I am part of Team B within Team A and the profile for Team B is Read-Only Default - then logically my rights are also read-only (by inheritance) - so how can I find that? Similarly, if I'm looking at a record owned by Team A - the function would return my read/write profile ID (or name)

The function should take the current userid and the ID of the team for the record I'm on - and pass back either an ID/Name of the relevant profile in use.

--
Regards
Mike

[RJLedger · Accepted solution]

Hint...

SELECT PROFILEDESCRIPTION,*

FROM SECRIGHTS A1, SECPROFILE A2

WHERE A1.PROFILEID = A2.PROFILEID

      AND A1.SECCODEID = 'WhatSecCodeFromOpportunityIamLookingAt'

      AND A1.ACCESSID = 'CurrentUserIDvalue'

Starting point ;-)

[MikeSpragg]

Good Hint !

[RJLedger]

Welcome!