Can someone tell me what privileges are required to deploy Oracle changes to the target database? These deploy scripts potentially include create table scripts. That's not such a big deal as the CREATE_ANY_TABLE grant can be given, but what if constraints need to be created, usually as part of the create table? As far as I can tell, one would need DBA access to be able to do so. That being the case, do you have to run the compare/deploy as a user that has DBA?
For some background we are doing a compare/deploy from DB to scripts, and then taking those scripts into a segregated environment and then doing a compare/deploy from those scripts to DB.
Thanks in advance!