Form Level Security

Posted on 2003-11-14
Last Modified: 2013-12-18
Hi all, i have a form which multiple people fill out. Rather than have a different view for each person so they can not see each others forms, how could i have just 1 view and the people would see only forms they submitted. Basically is there a way on the form i can say who ever orginally created this and the admin role can see this particular document, but no one else can.

Jason Incarnato
Question by:unknown45
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
  • 2
LVL 31

Expert Comment

ID: 9750377
Add two COMPUTED WHEN COMPOSED readers names field, with the following formulas:

1: @UserName
2: "[Administrator"

(For #2, ths would be to allow reading by anyone that has an ACL role of Administrator.)
LVL 24

Expert Comment

ID: 9750451
Setting up the readers field is the way to go. Not necessarily two fields a single field with multi values will do.

The formula should be like this

@Unique(DocReaders : @UserName : "[AdminRole]")

Second consideration that might have to be taken care would be to Enable "Don't show categories having zero documents" if you have categorized column in the view. This setting is available in Views property .. Advanced tab.

LVL 31

Expert Comment

ID: 9750467

I like two fields because of all the times I've seen people forget to check off "allow multiple values," and then nobody has access.  I've seen top dog Notes guys get themselves in a bind this way!
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!

LVL 24

Expert Comment

ID: 9750508
I agree, But there were situations where people forgot the existence of other readers/authors field and get into trouble.

Author Comment

ID: 9750524
I have everyone listed in the access control list of the database and most of them have over reader rights, so then all of them would be able to access this document. If i remove them from the database ACL list then they couldn't access the form correct?
LVL 31

Accepted Solution

qwaletee earned 500 total points
ID: 9750616
I'm not sure what you just said, very confusing language.

Readers fields are an optional setting on documents that restricts who can see the document.  No reader field (or all blank reader fields) provide no restriction.  Adding a readers fields means that only those listed in teh readers field (or the combination of people listed in multiple reads fields) will get to see the document, regardless of ACL settings.  So, the readers field has nothing to do with ACL reader access, or acl author access, or acl manager, etc.

Author fields are different.  They allow "editor" access to a particular document for someone listed in the ACL as Author; otherwise, that person is treated as a reader of the document.  (In addition, the Author field overrides reader restrictions - an author is always treated as a reader, even if not explicitly listed in a reader field.  if there are no reader fields, or only blank reader fields, this does not apply, as there are no reader restrictions there anyway.)

If you are not listed in the ACL at all, then default access applies to the user.

I will reiterate on point: If you are listed in ACL as a reader, but there is a document with a readers field in it, then you will NOT be able to read that document unless you are also in teh reader field for that document. Reader access has NOTHING to do with reader fields.

Author Comment

ID: 9750649
Thanks, Qwaletee. Yes I guess I didn't express myself very clearly but you did a good job a deciphering it!

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
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…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

732 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