Home > Development, Implementation, SQL > Copy the User/Module Authorization from one Syteline DB to another DB

Copy the User/Module Authorization from one Syteline DB to another DB

January 17th, 2011 Leave a comment Go to comments

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

Categories: Development, Implementation, SQL Tags: ,
  1. No comments yet.
  1. No trackbacks yet.
You must be logged in to post a comment.