Page Comparison

...

4) To support the new person directory described above, stored procedures (SP) were created to execute large database operations.  Following each create statement, there is a statement to grant permissions to execute the SP included in the 2.5.1 release.  For SQL Server implementations, the grant statement may fail for certain account roles/permissions combinations.  Executing the grant statements independently is highly recommended.  The statements below cover the four new SPs and must be adjusted to replace 'ssp' with the db_username in the  from $SSP_CONFIGDIR/ssp-config.properties file. These statements also assume you're using the 'dbo' schema. If you're not, you probably know what the correct schema name is. Or check the value of db_schema in 

GRANT EXEC on dbo.REFRESH_MV_DIRECTORY_PERSON to ssp;

GRANT EXEC on dbo.REFRESH_MV_DIRECTORY_PERSON_BLUE to ssp;

GRANT EXEC on dbo.update_directory_person_from_view_where_school_id to ssp;

GRANT EXEC on dbo.update_directory_person_from_view_where_person_id to ssp;

...