I’m thinking there might be some rights needed for the team coding user or that there might be something left out of the script to create the team coding objects. This is in the GA.
I dropped all the team coding objects and had our DBAs run the script Toad provides. Then I logged in as the Team Coding user who owns all the objects. When I added my project, I didn’t get any errors, but the only schema I could select was the one I was logged in as.
I then granted the tc_admin_role to my main user. I opened the config screen again and added my schemas and selected which types of objects I want to control. When I clicked OK, I immediately got two error messages saying I have insufficient privileges. After that I got a list of objects that were added to team coding.
I didn’t expect this problem, so I wasn’t spooling SQL. I am obviously missing some rights that I need under my non-TC user, and my TC user is apparently missing rights to be able to add other schemas to team coding.
I am now able to check code in/out using the GA and the Beta, but those error messages I got made me think things aren’t quite right yet.
Any thoughts on whether I need to try this again or get some rights adjusted?
Digital Products & Strategies, Cru | Data Sciences & Analytics