Solved

Restrict ability to edit a field

Posted on 2003-10-29
13
219 Views
Last Modified: 2013-12-18
I have several text fields on a form and I want to restrict who can edit the fields.  I want all users to be able to see the fields, but only database managers can edit the contents.

I see how to hide the field based on certain criteria, but that is not what I want.  Everybody has to be able to see the contents.

What is the best way to do this?

Thanks.
0
Comment
Question by:BECKETBM
  • 4
  • 3
  • 3
  • +2
13 Comments
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9643145
Use Controlled Access section.

Include all the fields into the controlled access section and give the formula for the section as who can edit the document.

eg: "[MGRRole]"

Where MGRRole is enabled for the managers who can edit the document.

~Hemanth
0
 
LVL 15

Expert Comment

by:Bozzie4
ID: 9643613
All fields ?

Give all your users Author access to the database, and use an Authors field to further give (edit) access to certain users.
You can do that using a role.

So add a field, type Authors, computed when composed, with formula "[MGRRole]".

If you want to protect only a couple of fields, you have several options.

You can use the Access Controlled section like hemanth suggest, but you must be aware that that is by NO MEANS as safe solution.  Everybody with Author rights for the document, can still change the values (albeit not directly, but through agents, smart icons, ...).

Better (safer) alternatives include :
- create separate documents (eg. responses) to store the protected values, and show them in the parent document through  computed for display fields with @dblookup
- use the Field Security Options, must have Editor access to use.  This implies giving the managers Editor access to the database - they would be able to edit ALL documents they can see, so this maybe not what you want

cheers,

Tom
0
 

Author Comment

by:BECKETBM
ID: 9644248
Thanks for your suggestions everbody!

I have a follow-up.  I have tried using the controlled access section, which works fine, except that I can not seem to get the section to apply to more than one row in a table.  The table is used to align the various fields on the form; 2 columns, one for the label and one for the field and then 6 rows.

Can a controlled access section apply accros an entire table?

Thanks.
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9644431
Yes, it can accomodate whole para or whole table
0
 
LVL 15

Expert Comment

by:Bozzie4
ID: 9644434
Put the table in the section, not the section in the table;
0
 
LVL 31

Expert Comment

by:qwaletee
ID: 9648360
What they both me is:
1) Select the entire table, from above the table to below the teble (add a few blank lines in both paces to make sure you get this right, you can select some of the extra blank lines)
2) WIth all of the tabel selected, Create -> Section -> COntrolled Access Section

Note: you can hide the "section header" for a more natural look.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:BECKETBM
ID: 9694142
What if I just want the section to apply to a part of a table, just a few rows and columns?  I am only able to insert a controlled access section in each individual section.  When I aelect multiple rows or columns it does not seem possible to add a section.
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9694314
You cannot do that. Rather you can select individual cells and enable controlled access section but that is too messy.. Can you split the table into two so that one has controlled edits and other doesn't ?
0
 
LVL 31

Accepted Solution

by:
qwaletee earned 125 total points
ID: 9698408
No can do directly. But you can nest table (create one table inside anotehr), for a similar effect.
0
 

Author Comment

by:BECKETBM
ID: 9701424
qwaletee:

In one of your earlier replies you said it is possible to hide the section header for a more 'natural' look.  How do you do this?

I have removed the title text for the section but the space that is reserved for the title text is still there and it looks like there is an additional line in the table.

Also, when I enter the application as a user, I can still expand and collapse the section, thereby hiding the fields in the section.  I don't want the user to be able to do this.  I want the section always expanded.

Any ideas?

Thanks.
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9701513
Goto property of section and select auto-expand for all choices and both editors and non-editors. THen goto hide tab at last and select all print/edit/read checkboxes.. so that section header is hidden and is always expanded.
0
 
LVL 31

Expert Comment

by:qwaletee
ID: 9709055
Hemantha's answer is what I meant, and solved both problems -- there is no appearance of a section,a nd the user can't collapse it.
0
 

Expert Comment

by:blossoming_flower
ID: 10288870
can anyone help....I have a section containing a table and it will not work via the web. Are sections actually compatible with the web. When the twisty is clicked, it expands (at least the expand graphic appears) but shows nothing.

Anthea
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
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…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

896 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

13 Experts available now in Live!

Get 1:1 Help Now