Decoding the "perms" column?

[rjchavez]

Has anyone been able to decode the bit values of the "perm" column found accross several of the CMDO tables?

I figure I can probably decode by updating each value and displaying the row for the particular table but thought someone may have already done this?

[rjchavez]

Here's what I have from a previous release for the ARSFOLPERMS table:

Bit-8 = Access Flag
Bit-7 = Fields Flag
Bit-6 = Admin Flag
Bit-3 = Public Flag
Bit-2 = Private Flag
Bit-1 = View Flag

Bits =8,7,6 OFF = NO ACCESS

[jsquizz]

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.

[rjchavez]

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*