• delete from up_permission where activity in ('PERSON_TEST_READ','PERSON_TRANSCRIPT_READ');
• delete from up_permission_activity where activity_fname in ('PERSON_TEST_READ','PERSON_TRANSCRIPT_READ');

Add new permissions for configurable Confidentiality Levels

• ant -Dmaven.test.skip=true -Ddir=uportal-war/src/main/data/ssp_entities/patches-SSP-2-1-0/SSP-1466 data-import

Add new bulk reassign permission for the Caseload Reassignment tool

• ant -Dmaven.test.skip=true -Ddir=uportal-war/src/main/data/ssp_entities/patches-SSP-2-1-0/SSP-1762 data-import

Add SSP adminsitrators to the uPortal administrators group

• ant -Dmaven.test.skip=true -Ddir=uportal-war/src/main/data/ssp_entities/group_membership/Portal_Administrators.group-membership.xml

Correct the DATA_ENGLISH_SECOND_LANGAGE permission

• update up_permission set activity = 'DATA_ENGLISH_SECOND_LANGUAGE' where activity = 'DATA_ENGLISH_SECOND_LANGAGE'
• update up_permission_activity set activity_fname = 'DATA_ENGLISH_SECOND_LANGUAGE', activity_name = 'DATA_ENGLISH_SECOND_LANGUAGE' where activity_fname = 'DATA_ENGLISH_SECOND_LANGAGE'

New Confidentiality Levels

• define approach for generic levels
• define access by users when creating/editing an entity
• any new generic CL defined should be added to oauth perms to access the new CLs

External Table Database update

The external_student_test table has a new column named discriminator and included in the primary key definition.  When deploying 2.1, the new column will be added regardless of the values of db_liquibase_external_apply_natural_keys.  The default value of 'discriminator' is '1'. The application does not care what values are set.  It is intended to be a completely opaque value used exclusively to distinguish between multiple completion of the same test on the same date.  The application will fail to start if duplicate data exists in the table.  In those cases, follow the steps below:

• Deploy and start up the 2.1 code with db_liquibase_external_apply_natural_keys=false. This will create the new column and fill in default values (1).
• Adjust or reload the external_student_test table with discriminator values to eliminate duplicate keys
• Restart the application with db_liquibase_external_apply_natural_keys=true. This will attempt to add a primary key to this table, including the discriminator column.