mercredi 4 février 2015

How to change the owner of a Stored Procedure in DB2?


Let's say that I have a procedure called schema.proc1. How do I change the owner of it? I'm using db2 express-c 10.5


I've tried the following command running as the olduser,



transfer ownership of procedure schema.proc1 to user newuser preserve privileges;


I want to do this because I believe this is a constraint that I'm having to not being able to create or replace schema.proc1 as newuser.


Thanks in advance!





Aucun commentaire:

Enregistrer un commentaire