PowerCampus - Creating an Alternate SQL 2005 User
This document will cover creating a new user in SQL 2005 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.
2. Right click on Logins, select “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. Click on Server Roles, verify that ‘Public’ is selected:
5. Click on User Mapping, select the database you want and verify that your ‘New User’ is listed at a User. It should automatically check the database role “public” for you. Click OK.
6. Open the ‘New User’ Properties from within the database, follow the following path:
7. It will bring up this screen, click on 'Securables':
8. Under ‘Securables’, click on ‘Add’, select ‘Specific objects…’, click OK.
9. Select ‘Object Types…’
10. Check off ‘Tables’, click OK:
11. Click the ‘Browse’ button:
12. Check all of the needed tables listed below to meet your Import needs, Click OK:
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
13. Click OK again:
14. You will need to check ‘Grant’ for the following Permissions: INSERT, SELECT and UPDATE rights for each table (Academic is shown, but highlight and complete for each needed table):
15. Click OK – Your New User is now complete.