Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Silver Super Contributor
Posts: 801
Registered: ‎03-24-2009
Accepted Solution

Security Profiles and Inheritance

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
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Security Profiles and Inheritance

Hint...

SELECT PROFILEDESCRIPTION,*

FROM SECRIGHTS A1, SECPROFILE A2

WHERE A1.PROFILEID = A2.PROFILEID

      AND A1.SECCODEID = 'WhatSecCodeFromOpportunityIamLookingAt'

      AND A1.ACCESSID = 'CurrentUserIDvalue'

 

Starting point ;-)

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Silver Super Contributor
Posts: 801
Registered: ‎03-24-2009

Re: Security Profiles and Inheritance

Good Hint !
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Security Profiles and Inheritance

Welcome!
--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html