How to identify permission changes to a specific table for a specific user or group 


Example SQL Query

SELECT * FROM LOG WITH(NOLOCK)
WHERE CD = 'UGPCHG'
AND RCD = 'SC=0 UID=23 TC=SEC FC= YR=0'

Example Aeries Query
LIST LOG CD OB DT USR SC ID CO RCD OD ND DTS IF CD = "UGPCHG" AND RCD : "SC=0 UID=23 TC=SEC FC= YR=0"


  • SC  - replace 0 with desired school code (only applicable for student and parent portal groups)
  • UID - replace 23 with the desired user or group ID
  • TC  - replace SEC with desired table code
  • FC  - replace '' with desired field code, if applicable
  • YR  - replace 0 with 1 for last year, 2 for all prior years, or leave at 0 for current year