This guide provides guidance on the permissions necessary for CL Connect to utilize the Banner stored procedure template we provided you.
By default our Banner stored procedure is built on the BANIST1 schema. However, schools can place this anywhere they like. Below are the permissions that need to be granted to the dB user that CL Connect is using to execute the stored procedure. These permissions were provided to us by a database administrator from a customer who completed the integration.
Please note this might need to be customized to reflect specific functions in your own integration. Also, these permissions were granted on the CLOGIC schema that this school installed the procedure into.
GRANT CREATE TABLE TO CLOGIC;
GRANT EXECUTE ON BANINST1.GB_COMMON TO CLOGIC;
GRANT EXECUTE ON BANINST1.RP_REQUIREMENT TO CLOGIC;
GRANT SELECT ON FAISMGR.ROBINST TO CLOGIC;
GRANT DELETE, INSERT, SELECT, UPDATE ON FAISMGR.RRRAREQ TO CLOGIC;
GRANT SELECT ON SATURN.SPRIDEN TO CLOGIC;
GRANT CREATE PROCEDURE TO CLOGIC;