Archives
If you have hundreds users, manually rebuilding the User/Module Authorization will be painful. The below query will copy over the User/Module Authorization from source DB to target DB. Just run it against your target DB. insert modulemembers (objecttype, objectname, modulename, originalmodulename, modulememberspec) select objecttype, objectname, modulename, originalmodulename, modulememberspec from [Your_Source_DB_name].[dbo].[modulemembers] where objectname like ‘OS_%’
Tags: Authorization, module