You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to apply data security for sql Queries in Data sets to be like custom subject areas?

Accepted answer
31
Views
4
Comments
edited May 22, 2023 8:54AM in Reporting & Analytics for Sales 4 comments

Summary:

I need to apply security part for the SQL Queries

Content (required):

We have reports for custom objects, these reports Data models created by SQL Queries,

We are facing issue that data security not applied aotumaticall, and all users can access all records including have not access to it.

So I need to apply this security part for the SQL Queries

Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

SELECT PaymentPlan.EXTN_ATTRIBUTE_NUMBER017 InstallmentNumber,

    LKP_SalesStage.MEANING InstallmentNumberDescription,

    PaymentPlan.EXTN_ATTRIBUTE_NUMBER014 COMPLETIONPROGRESS,

    PaymentPlan.EXTN_ATTRIBUTE_NUMBER016 InstallmentAmount,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!