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...