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