Answered by:
CRM 2013 field level security issue/bug?

Question
-
The issue arises whilst trying to update a record that has a field with field level security turned on, but was created BEFORE the field was added to the entity.
I.e
Create and Save a Record - RecordA
Add a new field (booleon) to the entity with field level security on, default the value to be No
Create and Save a Record – RecordB with the Boolean field left as default - No
Create and Save a Record – RecordA with the Boolean field set to Yes
Quering the database at this point would show the following
Record Name, field
RecordA, null
RecordB, 0
RecordC, 1
If you now try to open/save/change status of RecordA with a user which doesn’t have a field level security profile to that field then it fails, the record is then unusable until you assign the user permission to UPDATE the field.
It seems CRM is trying to set the NULL records to 0 (default) even though the user doesn't have permission to in the security profiles.
As its CRM Online, whats the best way to update all the null values to 0 without effecting the modifiedon dates?
Thanks
Pete
Monday, January 27, 2014 4:10 PM
Answers
-
I've logged this bug on Connect already (two iterations actually)
I'm not sure you are going to be able to update a records without affecting the Modified On date.
If that is a big concern and you can't un-secure the field you migth be stuck :(
Jason Lattimer
My Blog - Follow me on Twitter - LinkedIn- Edited by JLattimerMVP, Moderator Monday, January 27, 2014 5:32 PM
- Proposed as answer by JLattimerMVP, Moderator Monday, January 27, 2014 5:33 PM
- Marked as answer by JLattimerMVP, Moderator Tuesday, April 8, 2014 12:59 PM
Monday, January 27, 2014 5:30 PMModerator
All replies
-
I've logged this bug on Connect already (two iterations actually)
I'm not sure you are going to be able to update a records without affecting the Modified On date.
If that is a big concern and you can't un-secure the field you migth be stuck :(
Jason Lattimer
My Blog - Follow me on Twitter - LinkedIn- Edited by JLattimerMVP, Moderator Monday, January 27, 2014 5:32 PM
- Proposed as answer by JLattimerMVP, Moderator Monday, January 27, 2014 5:33 PM
- Marked as answer by JLattimerMVP, Moderator Tuesday, April 8, 2014 12:59 PM
Monday, January 27, 2014 5:30 PMModerator -
Thanks Jason, glad to know we're not the only ones :)
Very annoying.
Pete
Monday, January 27, 2014 5:32 PM