If for any reason you need to apply security against the GP tables eg. after an upgrade you can manually add the permissions with the following scripts.   Running the upgrader will also re-apply the security.


GRANT SELECT ON IV00101 TO HZS_HQMS

GRANT SELECT ON IV00300 TO HZS_HQMS

GRANT SELECT ON IV30400 TO HZS_HQMS

GRANT SELECT ON IV00301 TO HZS_HQMS

GRANT SELECT ON IV00200 TO HZS_HQMS

GRANT SELECT ON IV30400 TO HZS_HQMS

GRANT SELECT ON PM00200 TO HZS_HQMS


GRANT SELECT ON RM00101 TO HZS_HQMS


GRANT SELECT ON SOP10100 TO HZS_HQMS


GRANT SELECT ON POP10100 TO HZS_HQMS

GRANT SELECT ON POP10500 TO HZS_HQMS

GRANT SELECT ON POP10330 TO HZS_HQMS


GRANT SELECT ON WO010032 TO HZS_HQMS

GRANT SELECT ON WC010714 TO HZS_HQMS