Solved

Field Modification Rights

Posted on 2003-11-25
6
236 Views
Last Modified: 2013-12-18
How does one set a field so that anyone with editor rights can initially edit a field when the doc is created, but than restrict it so only a certain person can modify it.
0
Comment
Question by:schmad01
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 31

Expert Comment

by:qwaletee
ID: 9817804
Hi schmad01,

Simplest way: set the field to require EDITOR access.  Then make the "higher level" users editors, and the "lower level" users into Authors.  Of course, if these "authors" need to be able to edit any document (just not this field), set up a role in the ACL called [AllCanEdit] then create a computed author field wth formula "[AllCanEdit]"

Now, on creation, all fields -- including the "editor only" field -- can be edited by anyone.  As soon as the doc is saved the first time, any further changes to this field will be limited to editors -- even if someone has authro access to a particular document, authors are locked out of the particular field.

Where this scheme won't work:  if the "higher level" users need to have Autgor-only access, and you can't assign editor.  You can code around that, but it won't truly be the same.

Best regards,
qwaletee
0
 
LVL 31

Expert Comment

by:qwaletee
ID: 9817813
The other way to do this: put the field in a section, with a computed for display section formula, "[RestictedAccess]"

Create that role in the ACL, assign appropriate users.  If you expect thereto be any local replicas, you will need Enforce Consistent ACL.

This is NOT secure, but a convenient way to "direct" who can access the field.
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9818032
You should not hard code the role into the controlled section.. this will effectively block edit rights on the fields in this section right from the start.

So you have to compute it when it is saved

Create a field called EditAccess, computed with formula
@If( @ISNewDoc; ""; "[EditRole]");

EditRole is a role that is defined in the db acl and assigned to the group or group of user ids.

Now the Controlled section should have formula refering this EditAccess field in the @ Formula tab. Just set the type to Computed and enter

EditAccess

Now whenever you create a doc, this section fields are open for edits.. and when it is saved this is blocked to the role that is defined in the EditAccess field

~Hemanth
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:schmad01
ID: 9818033
Actually, the users have Editor access already so I guess I will have to go with a computed access section and use roles?
0
 
LVL 31

Accepted Solution

by:
qwaletee earned 125 total points
ID: 9818441
I suggest taht if the users already have editor acess, then yo shoudl go with my first suggestion.

Add the role.  Assign it to all users.  Add the author field.  Put the role in the author field.  Demote some users from author to editor.

Now, it looks like there is no change, because if you are in the authors field (via the role), it is the same as if you are an editor.

BUT... once you add the field restriction, authors will be able to create data in teh field on new documents, but as son as the document is saved, no more ability to edit that field for Authors, only for Editors.

It is a neat trick.  And it is completely secure.  The controled access method (my second post, as improved by Hemantha's post) is about the same level f difficulty to implement, and is not secure.
0
 

Author Comment

by:schmad01
ID: 9819652
Great. Thanks.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question