Restrict a Requester to their own templates

don-kintzle

Has anyone successfully restricted specific Requesters to their own Templates within Requisition Center?  Meaning allow them to access the Requester Templates but not have access to the Company or Location templates.  We have specific requesters that we would like the ability to restrict them to their own Template.  I tried to write a security rule on the TEMPLATE_REF field within PROCTMPPAR table but it doesn't appear to work as I expected.  Below is the rule that I wrote:

if(trim(user.getRequesterId())==trim(getDBField('PROCTMPPAR','REQUESTER','PROCURE_GROUP','TEMPLATE_REF','COMPANY','REQ_LOCATION','REQUESTER')))
'ALL_ACCESS,'
else
'NO_ACCESS,'

It's quite possible that I'm not writing the rule at the correct level or possibly the wrong table?

Thank you in advance for any guidance.

unknown

Maybe someone else understands better the templates you are referring to.

But, for myself: Are you referring to Shopping - Requisition center?

If not, which template are you trying to impact...PO##?

Recently, we locked a specific role from editing a header on a form by making a new security class that always locked that header on that form, and gave that SC to the role, and removed the SC that lets others edit the entire form.