Archives

Posts Tagged ‘Authorization’

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_%’

Jan 17th, 2011 | Filed under Development, Implementation, SQL