![\"image\"](\"https:\/\/pitss.org\/files\/2014\/06\/image.png\" "\\"image\\"")
<\/a><\/p>\n2. Go to \u201cUser Access\u201d.<\/p>\n
3. Expand your group name to find your PITSS.CON user by clicking the \u201c+\u201d button next to the group name. In this example, the PITSS.CON user we want to load database objects into is in the group \u201cUSERS\u201d.<\/p>\n 4. Select the PITSS.CON user inside the group. In this example, we are selecting the PITSS1 user. Once this is done, you will notice that the Users table may fill in with different schemas. Once your PITSS.CON user is selected, click \u201cChange Connect String\u201d to update the connect string to your application database.<\/p>\n NOTE: If the PITSS.CON group the PITSS.CON user belongs to has any database objects already loaded, they will need to be removed from the PITSS.CON repository before continuing. Otherwise, you may encounter an error when selecting \u201cChange Connect String\u201d.<\/strong><\/p>\n 5. Enter the username, password, and connect string of your application database userid. In this example, we are using a user called \u201cadmin\u201d. Click \u201cTest Connect String\u201d to save the connect string. NOTE: Make sure the application database userid you are entering has the \u201cselect on v_$database\u201d grant given to it.<\/strong><\/p>\n 6. Click \u201cOK\u201d when asked if you want to save as the new working database.<\/p>\n 7. The Application Connection field will be updated with the specified userid. In the Users table, you should see a list of all available schemas on the application database. For the schema you wish to assign the PITSS.CON user to, select the row with that schema and select the \u201cAssign a PITSS.CON User\u201d button. In this example, we are assigning the PITSS1 user to the WEBUTIL schema.<\/p>\n 8. Select the PITSS.CON user you wish to assign to the schema and click OK.<\/p>\n 9. You will see that the PITSS.CON user is assigned to the application schema. Repeat steps 7-8 for as many schemas as needed.<\/p>\n 10. Log out of the MIG user and log into your PITSS.CON user.<\/p>\n 11. Go to Administration \u2013> Settings.<\/p>\n 12. Scroll down to \u201cConnection String to Application Database\u201d and select it. You will need to provide the same application database connect string in these fields as you did in the MIG user. Click \u201cTest Connect String\u201d to save the changes.<\/p>\n 13. If successful, you should see a message at the bottom saying, \u201cThe connection string is correct.\u201d<\/p>\n 14. Click the \u201cExit\u201d button to return to the main menu. Go to Maintenance \u2013> DB Handling.<\/p>\n 15. Click \u201cLoad\u201d to start the loading procedure for loading the database objects.<\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n