Written on February 8, 2010 at 1:11 am by neel

Make record editable for some and read only for some?

Filed under Configuration View Comments

There are lot of variations of this question such as:

  1. There are two type of users, sales user and risk user. The Differentiating factor between them is User Type in Employee table. How can we configure that for risk user the records are editable and for sales user it is not.
  2. How can a view be read only for a particular user and editable for the other user?


But in short we need to answer how to make a view read for some users and editable for some users.

Answer:

Create two responsibilities named Sales_User and Risk_User. Assign the view to both responsibilities and for Risk_User responsibility make “Read Only View” flag as true.

Now add sales users to Sales_User Responsibility and Risk Users to Risk_User Responsibility. Now for Risk_User records will be read only and for Sales user records will be editable.

Related Questions

Subscribe / Share

Article by neel

Authors bio is coming up shortly. neel tagged this post with: , , Read 39 articles by neel
  • I was under impression that view read only will result in record read only also.... isn't that case ????
  • Bejoy
    View read only would make the entire view read only i.e. child, grand child and all other applets. I dont think the above question is to make the entire View Read only. If the question is for the entire view, then it shouldn't say "Record" should be "View" rather.

    Its one of the questions I ask during the interviews...;-)...
  • You do have point :)
  • Bejoy
    The Question says "Make [b]record[/b] editable for some and read only for some?" not [b]View[/b]

    To make a record read only follow the below steps.

    1. Add the Type field as a join from S_EMP_PER to the Personalization Profile BC as a field. This will set a profile attrib everytime user login.
    2. Make a calculated field in the actual record BC to check if the profile attrib says its a Sales User or Risk User. The calculated field should return a Y OR N. Depending on for which user you want to set record to be read only. In this case for Risk User it should return Y.
    3. Create a BC Read only user prop and add this calculated field to the value.

    This will make the record read only for Risk User and editable for Sales User.
blog comments powered by Disqus
analytics base tables Black Box Testing business component business components business service business services Configuration EIM eScript exception handling exceptions fact tables Functional Testing Informatica Interview Link Specification Local Client memory management mvl parent child relationship Position QTP repository Responsiblity Scripting Search Spec sequence generator server administration server requests siebel Siebel EAI Siebel Testing Siebel Tools Software testing Software Validation surrogate key synchronous execution synchronous mode table tables testing User Properties User property workflow Workflows