Skip to Content
Aug 21, 2016 at 04:40 AM

Procedure added in role created in REPOSITORY is deactivated


Dear colleagues,

I created a role in RESPOSITORY, I,e repository role not SQL role,

In that Repository role I added couple of procedures and activated it in DEV, TEST and PRODUCTION systems, role is working fine,

When some changes has been done in the procedure in the development system and it is transported to the next systems then the procedure is getting disappeared in my repository role,

Every time I have activate the role again and again after the transport is done,

any solution for this, please...