Mostly resolved Re: Write permissions errors with read (floating) license
Thanks Doug, you nailed it. (Sound of palm slapping forehead, and/or egg running down face) We changed server hardware, and have since discovered that some of the fields on the new server are missing permissions. The database had been ported over from the old server, so ostensibly the objects would have been the same. But somehow, the old permissions were completely missing from certain fields. (That all happened before I arrived on the scene -- all I can tell is that no one had modified those objects in the meantime.) I took it for granted that the object defs would be the same on both servers, but apparently (at least in this case) this was a reckless assumption. Only a few fields have the issue; I haven't found any pattern as to how or why. Furthermore I haven't found an instance where some of the permissions were missing and some were retained -- they're either all there or they're all missing. So, this leads me to another question -- is there a quick and/or easy way to identify all fields (in any and all forms) that do not have any permissions at all? (I don't have access to Migrator, though I recall it just tells you that there's a difference in permissions -- not necessarily what those differences are.) Thanks again, Joe ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Mostly resolved Re: Write permissions errors with read (floating) license
Joe, Arinside has a section that identifies that information On Friday, April 12, 2013, Joe Castleman joe.castle...@gmail.com wrote: Thanks Doug, you nailed it. (Sound of palm slapping forehead, and/or egg running down face) We changed server hardware, and have since discovered that some of the fields on the new server are missing permissions. The database had been ported over from the old server, so ostensibly the objects would have been the same. But somehow, the old permissions were completely missing from certain fields. (That all happened before I arrived on the scene -- all I can tell is that no one had modified those objects in the meantime.) I took it for granted that the object defs would be the same on both servers, but apparently (at least in this case) this was a reckless assumption. Only a few fields have the issue; I haven't found any pattern as to how or why. Furthermore I haven't found an instance where some of the permissions were missing and some were retained -- they're either all there or they're all missing. So, this leads me to another question -- is there a quick and/or easy way to identify all fields (in any and all forms) that do not have any permissions at all? (I don't have access to Migrator, though I recall it just tells you that there's a difference in permissions -- not necessarily what those differences are.) Thanks again, Joe ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Mostly resolved Re: Write permissions errors with read (floating) license
If you have access to the database you can run a query to find that out Something like select f.FieldID, s.Name from Field f, ARSchema s Where f.SCHEMAID=s.SCHEMAID and (SELECT MIN(p.GroupID) from Field_Permissions p WHERE p.SCHEMAID=f.SCHEMAID and p.FIELDID=f.FIELDID) IS NULL -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Castleman Sent: Friday, April 12, 2013 12:47 PM To: arslist@ARSLIST.ORG Subject: Mostly resolved Re: Write permissions errors with read (floating) license Thanks Doug, you nailed it. (Sound of palm slapping forehead, and/or egg running down face) We changed server hardware, and have since discovered that some of the fields on the new server are missing permissions. The database had been ported over from the old server, so ostensibly the objects would have been the same. But somehow, the old permissions were completely missing from certain fields. (That all happened before I arrived on the scene -- all I can tell is that no one had modified those objects in the meantime.) I took it for granted that the object defs would be the same on both servers, but apparently (at least in this case) this was a reckless assumption. Only a few fields have the issue; I haven't found any pattern as to how or why. Furthermore I haven't found an instance where some of the permissions were missing and some were retained -- they're either all there or they're all missing. So, this leads me to another question -- is there a quick and/or easy way to identify all fields (in any and all forms) that do not have any permissions at all? (I don't have access to Migrator, though I recall it just tells you that there's a difference in permissions -- not necessarily what those differences are.) Thanks again, Joe ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Mostly resolved Re: Write permissions errors with read (floating) license
Ah! Thanks for that. On Fri, 12 Apr 2013 12:58:21 -0600, Longwing, Lj llongw...@usgs.gov wrote: Joe, Arinside has a section that identifies that information ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years