Author Topic: Decoding the "perms" column?  (Read 142 times)

rjchavez

  • Jr. Member
  • **
  • Posts: 67
    • View Profile
Decoding the "perms" column?
« on: August 01, 2022, 11:21:46 AM »
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

  • Jr. Member
  • **
  • Posts: 67
    • View Profile
Re: Decoding the "perms" column?
« Reply #1 on: August 01, 2022, 11:26:35 AM »
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

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 510
    • View Profile
Re: Decoding the "perms" column?
« Reply #2 on: August 02, 2022, 10:18:21 AM »
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.
#CMOD #DB2 #AFP2PDF #TSM #AIX #RHEL #AWS #AZURE

rjchavez

  • Jr. Member
  • **
  • Posts: 67
    • View Profile
Re: Decoding the "perms" column?
« Reply #3 on: August 02, 2022, 02:23:50 PM »
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*