Our request is more related to a 'best practice' advice on how to overcome this issue.
In any 'traditional' software development scenario, a developer would run the precompiler and the compiler to generate an executable file plus a '.bnd' file.
After these two steps are complete, a user (usually with the proper BIND privileges and SELECT/INSERT/UPDATE/DELETE on DB2 objects) which may or may not be the same user that ran the precompile and compile steps, would run the BIND command to generate the package within DB2 and thus, leaving the program ready for execution.
Within MicroFocus' Enterprise Development IDE, this process is done by the ECM in a single step.
In our shop, we have a requirement from IS Department to have a predefined user to hold the 'BIND with OWNER' privilege and SELECT/INSERT/UPDATE/DELETE on all tables as the ONLY user to be the OWNER of all packages.
After implementing our project, we are getting SQLCODE -552 stating that the userid running the compile does not hold the 'BIND with OWNER' privilege. This error was expected since the userid does not have that provilege and, by IS policy, should never have it.
We are trying to find out whatever steps are needed to implement this scenario. We think that maybe we need to implement a sort of 'surrogate' script/proc that executes the BIND portion of our compiles.
Do you know if somthing like this can be done...?
I hope I described our scenario properly.
Any help would be greatly appreciated.
#EnterpriseDeveloper