Different Users and Mapping does not work!

KentWA

User Mapping Does not work.

All the objects in my DB are Owned by dbo (i.e. [dbo].[users] my source and target have different users that are members of dbo. Even when I map the users properly SQL Compare attempts to still creates the line:

GRANT EXECUTE ON [dbo].[aspnet_AnyDataInTables] TO [hawkwin_portaluser]

Which is the user in the source DB and does not exist in the target. I finally had to copy the script to SQL Studio and manuall change that line. However I want to automate this and not have to go through this step.

How do I get it to GRANT ACCESS to the proper user?

Thanks,
Kent

Eddie D

Thank you for your post into the forum.

There is no functionality within SQL Compare to Map Users or Logins. There is the ability to Map Owners or Schemas.

When you create a comparison project and you have selected your data sources, SQL Compare automatically maps objects with the same name and the same owner (SQL Server 2000) or schema (SQL Server 2005) for you.

If you want to compare objects with the same name but those objects have different owners or belong to different schemas, you can map the owners or schemas as required. For example, if you want to compare objects in a test database that are owned by sales with objects in a production database that are owned by support, you can map sales to support.

Can you please reply back with further information on what you are trying to achieve.

Many Thanks
Eddie

Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-Mail: support@red-gate.com