Protecting some fields

Posted on 2002-04-19
Last Modified: 2013-12-18
I have a document in which a remark can be added by 3 people in 3 different fields.Now I want the comment added by 1 can be read by 2 and comment added by 2 can be read by 3 but not vice-versa.1 can read rest of the data in the doc but not the comment added by 2 or 3.If 3 allows then only 1 can read comments added by 2 & 3.
My problem s even if I hide the field when 1 goes to doc properties the hidden fields will also be visible.

I thought of encryption of the fields as a way but that would increase a lot of administrative overhead.
Can anybody suggest a way to stop the data from being seen in the document properties.
Question by:sampa
  • 4
  • 3
  • 2
  • +1

Expert Comment

ID: 6955864
The best bet would be to to use encryption keys.  Cause the document property reveals everything even if you hide the fields.

Now, if its only edits then you could better use access controlled sections but...this is for read so, you gotta go for encryption keys.

Create  encryption keys and distribute it accordingly.
Create field named secret encryption keys field to populate the keys by the user accordingly. The best way to secure field data.

Good Luck!
LVL 24

Expert Comment

ID: 6957664
Here is a tip.

Create additional form called "frmComments" (Response)
With fields, Comments (RichText), DocAuthors(Authors), DocReaders(Readers)

Whenever user enters a comment, use the frmComments and stamp DocAuthors and DocReaders with appropriate usernames.Mostly DocAuthors will be the current user and DocReaders would be the next user who has to read the comment.

So in total for each Main document, there will be 3 frmComments form as response.

Advantage, no need to maintain encryption keys. But still control the access to the data by using readers field.

If you need more details let me know.


Author Comment

ID: 6959423
Sorry folks for wasting ur precious time but got some info to give.When u make an .ntf of ur db and then create another db and replace the design with the existing .ntf, then the document properties are not visible.
But while replacing design the lotus script & formulas have to be unchecked.

Thanks for the help.
Both Hemanth & Arunkumar ur suggestions have been helpful for me.

Expert Comment

ID: 6959437
You are right.  The fields wont be visible if you hide design from users...

But still you can write a lotusscript on the document to extract the field name and its values clearly if you dont encrypt the field content !!!

Just saving my comments you see!

LVL 24

Expert Comment

ID: 6959848
Glad that you found a solution.

I don't know about the policy of your company. But most of the companies do not encourage the use of Hiding design. If your client allows then no one is stopping you from doing that.

Here in this forum, check how many people wanted a solution for getting back design which was hidden by this method. In R4, there was a back door so everyone got through it, in R5... you have to live with that.

So use it cautiously !!!
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails


Author Comment

ID: 6961902
Yah u r right Hemanth.It's not for my company but for a project I am working on.
Actually the client wants the code also.We r going to put forward all solutions n they will decide what is the best way they want to work around it.
I too think encryption is the best way to work around it.If that is not accepted the .nsf and .ntf will be given for them to go across the same process which I did.
LVL 24

Expert Comment

ID: 6962597
Good luck then !

Expert Comment

ID: 6978499
You have open questions dating back to the year 2000.  ADMINISTRATION WILL BE CONTACTING YOU SHORTLY.  Moderators Computer101 or Netminder will return to finalize these if they are still open in 14 days.  Experts, please post closing recommendations before that time.

Below are your open questions as of today.  Questions which have been inactive for 21 days or longer are considered to be abandoned and for those, your options are:
1. Accept a Comment As Answer (use the button next to the Expert's name).
2. Close the question if the information was not useful to you, but may help others. You must tell the participants why you wish to do this, and allow for Expert response.  This choice will include a refund to you, and will move this question to our PAQ (Previously Asked Question) database.  If you found information outside this question thread, please add it.
3. Ask Community Support to help split points between participating experts, or just comment here with details and we'll respond with the process.
4. Delete the question (if it has no potential value for others).
   --> Post comments for expert of your intention to delete and why
   --> YOU CANNOT DELETE A QUESTION with comments; special handling by a Moderator is required.

For special handling needs, please post a zero point question in the link below and include the URL (question QID/link) that it regards with details.
Please click this link for Help Desk, Guidelines/Member Agreement and the Question/Answer process.

Click you Member Profile to view your question history and please keep them updated. If you are a KnowledgePro user, use the Power Search option to find them.  

Questions which are LOCKED with a Proposed Answer but do not help you, should be rejected with comments added.  When you grade the question less than an A, please comment as to why.  This helps all involved, as well as others who may access this item in the future.  PLEASE DO NOT AWARD POINTS TO ME.

To view your open questions, please click the following link(s) and keep them all current with updates.

To view your locked questions, please click the following link(s) and evaluate the proposed answer.

*****  E X P E R T S    P L E A S E  ******  Leave your closing recommendations.
If you are interested in the cleanup effort, please click this link
POINTS FOR EXPERTS awaiting comments are listed in the link below
Moderators will finalize this question if in @14 days Asker has not responded.  This will be moved to the PAQ (Previously Asked Questions) at zero points, deleted or awarded.
Thanks everyone.
Moderator @ Experts Exchange

Author Comment

ID: 6979544
I have found answer to my question so I would like the question to be a PAQ.

Author Comment

ID: 6979557
The answer to this question has been submitted as a comment by myself.
I would like my points to be refunded.

Accepted Solution

Moondancer earned 0 total points
ID: 6982200
Thanks, sampa, for adding the solution you found.  I have refunded your 100 points to you and closed this by moving it to our PAQ at zero points.
Moondancer - EE Moderator

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

708 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now