It is not generating the UserObjectPrivileges scripts correctly, it is using the folder name of the repository instead of the schema name we are versioning:
Here is an example:
GRANT EXECUTE ON "branches/devl/db/devl".function TO user;
Resolved as part of the beta 3 release
@Leigh - hopefully we've now addressed 1. Regarding 2 and 3, we appreciate your feedback. Currently our Schema Compare tool can be used to get around this, as it can script out files from schemas and can also be used for creating deployment scripts between environments. It is as yet undecided how we solve this problem for Source Control users who aren't going to use Schema Compare for deployments. Thanks for the migration feature suggestion, duly noted.
@Curtis - I'm delighted this now works for you, and will close this issue.
This works fine in our environment now since we have more flexibility in where we check out the code in our repository. As long as we follow the naming convention you have suggested we can run the scripts against production to create/update the affected objects for the version.
Michael, it sounds like you are bending over backwards to make the app operate nicely for shops that 1) Only use root folders for schema names 2) Use folder names that match production schema names but not dev/qa and 3) Aren't interested in running scripts on anything but production. This seems like an extremely narrow subset of customers you are catering too. I suggest you make the schema name in the script match the schema name in the database and then create a separate migration feature that could do schema name translation.
I think if you fix this http://redgate.uservoice.com/forums/174014-oracle-tools/suggestions/3652032-allow-source-control-in-sub-folders-of-repository then it will make this work better in our environment.
Neil did you make progress on this one?
Thanks for this. I'll have a look into it today and be in touch.
Update on this, it appears that this is the case in all scripts NOT just the UserObjectPrivs folder. Let me know if you need anymore information.