QUICK LINKS
Support
Issue Tracker
[Services]
Questions
[uAchieve 4.5 Applications]
[uAchieve 5.0 Application]
[uAchieve 5.1 Application]
Transferology
TES
[Training & Conferences]
Accessibility
The Connector depends on a uAchieve Server to provide degree audits
Two database connections are required to successfully produce degree audits through the Connector via uAchieve:
Keep the following points in mind to minimize degree audit troubleshooting when setting up database access and installing the Connector:
This section is important when the database user used by the uAchieve server is different than the schema owner of the uachieve tables. If the database user used by the uAchieve server is the same as the database owner of the uAchieve tables, the points in this section aren't necessary.
When the database user used by the uAchieve server is different than the schema owner of the uachieve tables, the database user for the uAchieve server must have the following minimum access (synonyms and privileges).
Private synonyms, as well as select, insert, update, and delete privileges on the CURRENT_JOBS and JOB_QUEUE_xxx tables.
Private synonyms and select privilege on the following uAchieve tables.
CHART_CATEGORIES COM CRS_CONVERT DPROG DPROG_REQ GMASTER MASTREF MASTREF_ADDRESS MASTREF_SEG REPEAT REQ_MAIN REQ_TEXT REQ_XY STRING STRING_CRSE SUB_REQ SUB_REQ_AR SUB_REQ_TEXT STU_ACADREC TCA_MASTER TCA_RULE TCA_SOURCE TCA_TARGET
Some schools want to prevent the Connector from accessing the enrolled student's audit data contained in the JOB_QUEUE_xxx tables used by the school's existing uAchieve Server.
The two alternatives below assume this initial setup, prior to performing the isolation steps:
The following sections identify the important points for the two alternatives.
This isolation requires three database users and is the most secure.
Database user specifics:
This isolation only requires two database users. It is slightly less secure than the above 3 Database User alternative.
Database user specifics:
It is accomplished with the following tasks: