Server Side Objects has been installed through the wizard. When Team Coding Status | Settings option is selected the following error occurs:
"Connection settings will be read-only. For read and write privileges, you must have be the Administrator Role."
The Grant to Public option was not selected in the wizard.
Remove Team Coding objects and recreate them via the Server Side Object wizard. When recreating these objects, check the 'Grant to Public' options in the Roles screen.
1. Select Server Side Objects wizard menu option under Tools or Database | Administer menu and and run it.
2. In the first screen, keep the first option selected and hit Next.
3. Login as TOAD to database.
4. Under Team Coding section, select "Remove" and hit Next**.
5. Hit Next again and select "Run Script" button (in case of any error warning, hit OK).
6. Hit Next and close the wizard.
7. Re-run Server Side Objects wizard.
8. Select the first option, hit Next and login as TOAD.
9. Under Team Coding section, select "Add" and hit Next.
10. Hit Next again, and login as a DBA role account into database.
11. Select all "Grant to Public" options and hit Next.
12. Select the Tablespaces and hit Next.
13. Select "Run Script" button and login as TOAD.
14. Hit Next and close the wizard.
15. Reconnect to database as TOAD.
16. Select Team Coding Status menu option and Settings option to setup and connect to VCS.
If this message is still being recieved after doing what is listed above and the user has appropriate roles and privileges granted to them. Check to see if all of the following roles are created in the database.
SQLNAV_ADMIN
SQLNAV_LDR
SQLNAV_MGR
TC_ADMIN_ROLE
TC_LDR_ROLE
TC_MGR_ROLE
If all six are created in the database, then either the set of SQL Navigator roles (prefixed with SQLNAV) or toad roles (prefixed with TC) will need to be removed. Neither application works correctly if both products team coding roles are created. Both product's team coding roles will work on the other product, so only one set of roles is needed.
**If Remove checkbox is disabled in the wizard, then perform the following:
1. In Toad's Editor enter and execute the following:
drop public synonym QUEST_COM_TEAM_CODING;
Commit;
2. Re-run the wizard and the Remove checkbox will be enabled.
When re-running Server Side Object Wizard, ensure to be logged in as a DBA.
