I currently have a test repository set up in the same schema as my code. I’d like to set up a shared repository so multiple developers can access and run different tests at the same time.
I have tried setting up different configurations identified in the Help documentation, but I must be missing something. Here’s what I’m currently trying:
schema A contains the code we want to test
schema B contains the Code Tester repository (tables and packages)
schemas C - n are specific developer accounts from which I’d like to be able to develop and run test cases
When I try to log into CT as user C, the tests fail to compile. When I try to troubleshoot the test code, I cannot even open the code (presumably because user B owns it).
I can log into CT as user B and run the tests, as long as user A grants EXECUTE permission on its code directly to user B.
What piece am I missing? The Help docs seem to indicate I should be able to develop and run tests as user C in this scenario.