What I personally do for these "cryptic" fields- is pick one row, make a change in the admin, then see what changes..via query. and note it.
This is what I've done. The PERMS column is a 2-byte binary field. The second byte remains the same as posted above with the exception of the
Fields value which is now on bit-5. There is also bit-4 which seems to be "on" whenever multiple values are selected.
Finally, the first byte contains the
Full Report value in bit-7. Here's the bit breakdown for the 2 bytes.
8 4 2 1 8 4 2 1 8 4 2 1 8 4 2 1
0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 000F Access+Admin+Fields Authority
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0001 Access
0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 1 0019 Access+Fields
0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 1 0211 Access+Full Report
0 0 0 0 0 0 1 0 0 0 0 1 1 1 1 1 021F Access+Admin+Full Report+Fields
0 0 0 0 0 0 0 0 1 0 1 1 0 0 0 1 00B1 Access+Public+View Named Queries
0 0 0 0 0 0 0 0 1 1 0 1 0 0 0 1 00D1 Access+Private+View
0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 1 0091 Access+View
0 0 0 0 0 1 1 1 0 1 0 1 0 0 0 1 0751 ALL
* All zeroes = *NO ACCESS*