I am doing a Training database refresh with production, after refresh I want to add users to training database who were in the training database originally.Can anybody send me if there is any script which generates user permissions, so I can run this script before refresh and apply the script after refresh, so I don't lose any users and user permissions.
It depends on the permissions. We exclusively use role based permissions, for this reason. When you refresh a database, all you need to do is assign the proper roles to the affected users, and call it done. What sort of permissions are unique to the training users that are not in production?