How to find Deny Permissions in a User Group. This can be done via a Query statement. Specify the Table and Field codes to refine the results.  Deny value = 2.

Example: STU table, NS field. Update the Table Code (TC) and Field Code (FC)  in the query, as necessary.

1. From the District Level: 

Open Query page and run this query:

• LIST UGP SC UID TC FC RD UP INS DL MU AD YR IF TC = STU AND FC = NS AND ( RD = 2 OR UP = 2 OR INS = 2 OR DL = 2 OR MU = 2 OR AD = 2 )  

2. The UserID can be searched on the Groups page, and corrections to the permissions can be adjusted if necessary.