I need to perform given below two task on same instance but want to avoid long and manual process to perform this for single-2 user.
Drop Users and Create users script could be generate through generate script option available on SSMS but I did not get any generate option for associated permission with users.
please suggest some process or script to perform task fast.
asked Apr 16 '12 at 04:52 PM in Default
You can take inspiration on cloning users rights in my post: Cloning user rights in database.
In this post is presented a system stored procedure to handle cloning, but you can easily update the solution to script rights for all users and roles.
Eventually you can call it in a loop for each appropriate user and/or role from the
answered Apr 16 '12 at 06:16 PM