Thanks for the info and time. In our current environment we don't have the liberty to stop and start servers and it needs to go through a process. The Denodo Server is hosted in a Unix machine and we use VDP admin tool on a windows machine to connect to the server.
I have the administrator privilege on the server and I deployed extension using my user name. I could see after it is deployed and after the first execution, somehow some process is getting tied to my user name and subsequent to that I am unable to remove the JAR file even though I am the administrator. Also, I had our administrator tried to remove the JAR file using his account and he gets the same message and unable to remove it.
Also, it is only the JAR files that have custom policies that have these issues. When I separate out the SPs and functions, I am able to easily remove and add JAR files.
Considering these below are my questions.
* What is the best practice to deploy JAR files containing custom policies? So, we could easily add and remove the JAR files while developing and testing those.
* For example if a custom policy gets modified and needs a newer version to be deployed, then do we need to remove all the occurrences where this policy is assigned and only then we could deploy the JAR successfully?
* Is there an out of the box stored proc to figure out all the views a custom policy is attached?
Please advise and let me know if you need any further information.