How to run the SQL Server grant and check permissions and privileges scripts? (4252740)

How to run the SQL Server database agent grant and check permissions and privileges scripts?

MSSQLPermissionsGrant.sql
MSSQLPermissionsCheck.sql

1. Create the SQL Server login/user that the Foglight database agent will use (e.g. FOGLIGHT)
2. Modify MSSQLPermissionsGrant.sql and specify the user that will be used under the @LoginName.  Execute the script as a sysadmin user.
3. Login as the FOGLIGHT user to be used by the agent via Management Studio.  Edit MSSQLPermissionsCheck.sql and specify the user under the @LoginName.   Execute MSSQLPermissionsCheck.sql.  This will check if the FOGLIGHT user or intended user has the correct permission.  A result of '1' means no permission.  '0' means permission is good.