PowerCampus - Creating an Alternate SQL Use
This document will cover creating a new user in SQL to use for either the Charge Credit Import tool, or the PowerFAIDS Import tool.
Prerequisites
In order for a UWS employee to access this, the following must be true:
Steps
1. Open Enterprise Manager. Go to Security, Logins.
On the right hand side it will show a list of logins like this:
2. Right click anywhere in that list of users and choose “New Login...”
3. Type in whatever you want your username to be. Then choose the radio button next to “SQL Server Authentication” and type in a password.
4. Skip over the “Server Roles” tab. You DO NOT need to assign anything here.
5. Go to the Database Access Tab. Select the database you want. It should automatically check the database role “public” for you. Click on the “Properties” button.
6. Click on the “Permissions” button
7. It will bring up this screen:
8. The follow section shows the rights for each table to for each Import tool. Basically, scroll down to each table and apply the SELECT, INSERT, and UPDATE rights on the tables (Academic is shown, but follow the tables on the next page for the appropriate import too):
PowerFAIDs Import
Needs to have Select, Insert, and Update rights against the following tables (asterisks indicate the new tables for 6.0):
- ACADEMIC
- ADDRESS
- BATCHHEADER
- CHARGECREDIT
- CODE_ACATERM
- CODE_ADDRESSTYPE
- CODE_APPSTATUS
- CODE_CHARGECREDIT
- CODE_COUNTRY
- CODE_ENROLLMENT
- CODE_INQSTATUS
- DEMOGRAPHICS
- EVENTATTRIBUTES*
- FINAIDMAPPING*
- PEOPLE
- PEOPLETYPE*
Charge/Credit Import
Needs to have Select, Insert, and Update rights against the following tables (asterisks indicate the new tables for 6.0):
- ACADEMICCALENDAR
- BATCHHEADER
- BILLINGLEVEL*
- CASHRECEIPT
- CHARGECREDIT
- CHARGECREDITLINE
- CODE_ACATERM
- CODE_CHARGECREDIT
- CODE_CREDCARDTYPE
- CODE_OFFICE
- FINAIDMAPPING*
- ORGANIZATION
- PEOPLE
9. After selecting all your tables for your particular tool, click “OK” on the Permissions screen. Click “OK” on the Database Role Properties screen. You should be back to the database selection screen. Hit “OK” here also. It will come up with the “Confirm Password” screen. Type in your password again, and hit “OK”.
That’s It! You’re user is now created and ready to use.