Team Coding Setup

Toad for Oracle - Beta
1

John,

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?

Blessings,

Phyllis

–
Phyllis Helton

Data Magician
Digital Products & Strategies, Cru | Data Sciences & Analytics
Office :phone: 407-515-4452

phyllis.helton@cru.org

2

Hey Phyllis,

It sounds like you’re working in an environment where database access is aggressively locked down. This may not specifically be a Team Coding issue, but rather an issue of database permissions set for your account.

The first issue you stated: where you couldn’t select any other schema except the owner of the Team Coding objects, sounds like that user only has access to its own schema and no others. In order to set up projects, you still need to have read-access to other schemas (and the objects within them that you wish to control) as well as read-write access to the schema where the Team Coding objects live. In fact, all users of Team Coding need to have read-write access to the schema in which the Team Coding objects exist.

The second issue you raised: where you received two error messages, is a bit harder to diagnose without knowing what the error messages you received were. It could have been permissions issues within the VCS or permissions issues within the database. It’s a bit difficult to tell. If you’d like, you can always try deleting and recreating the Team Project. If you do, let me know what the exact error messages were and we can try to diagnose it further.

Outside of that, I don’t believe there are any other special permissions required by the GA you would need to manually provide each user.

Let me know if there’s anything else I can do from my end to help!

-John

3

Oh, yeah, I figured it was Oracle permissions. I just wasn't sure what additional ones we might need for everything. I'll have our DBAs grant the TC user read/write access to the other schemas. I didn't realize it needed to write to them and didn't think about it being able to read them, though that makes sense.

And I realize you can't just know what the error was from my description, though I thought there was a slim chance there might not be enough it tries to do so you would know. Because things appear to be working, I think I'm going to just adjust the other grants and assume things are ok, unless you suggest I do differently.

Thanks for all your help in getting this set up!

On Tue, Apr 12, 2016 at 3:25 PM, John Bowman bounce-jbowman@toadworld.com wrote:

RE: Team Coding Setup

Reply by John Bowman
Hey Phyllis,

It sounds like you're working in an environment where database access is aggressively locked down. This may not specifically be a Team Coding issue, but rather an issue of database permissions set for your account.

The first issue you stated: where you couldn't select any other schema except the owner of the Team Coding objects, sounds like that user only has access to its own schema and no others. In order to set up projects, you still need to have read-access to other schemas (and the objects within them that you wish to control) as well as read-write access to the schema where the Team Coding objects live. In fact, all users of Team Coding need to have read-write access to the schema in which the Team Coding objects exist.

The second issue you raised: where you received two error messages, is a bit harder to diagnose without knowing what the error messages you received were. It could have been permissions issues within the VCS or permissions issues within the database. It's a bit difficult to tell. If you'd like, you can always try deleting and recreating the Team Project. If you do, let me know what the exact error messages were and we can try to diagnose it further.

Outside of that, I don't believe there are any other special permissions required by the GA you would need to manually provide each user.

Let me know if there's anything else I can do from my end to help!

-John

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - Beta notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag this post as spam/abuse.

--
Phyllis Helton

Data Magician
Digital Products & Strategies, Cru | Data Sciences & Analytics
Office :phone: 407-515-4452

phyllis.helton@cru.org