How does PINpoint interface with the BES SQL Database Server?
The PINpoint application will open connections to the BES SQL Server every time: • When data is pushed to BlackBerry devices • When the PINpoint list is refreshed from the device side • When the PINpoint Administrator is using the PINpoint management Console. Please see below a description of how PINpoint interfaces with the BES SQL server: • PINpoint relies only on SQL authentication. Because of this the BES SQL server should be set-up to support Mixed Authentication. • At installation time PINpoint Standard Edition creates the following objects in the BESMgmt database: • A role called PINpoint_DataReader • Three in-line functions: USR_PINPOINT_GET_BLACKBERRY_USER, USR_PINPOINT_GET_BLACKBERRY_USERS, USR_PINPOINT_GET_CONTENT_LIST • The installer will grant SELECT rights to the above In-line functions to the PINpoint_DataReader role. [NB. in a more restricted environment this step could be skipped at installation time: the application ships with the actual SQL scripts that could be hand
