The permissions required to compare and deploy a database using SQL Compare depend on the objects in your database schema and the version of SQL Server you are using.
For example, a user belonging to the
PUBLIC role can compare a SQL Server 2000 database. However, they can not compare encrypted stored procedures without dbo permissions.
To perform a deployment, we recommend you have dbo permissions.
If you create a deployment script to run later, you are also recommended to run the script as a dbo user. This ensures that any objects created will have the correct schema, permissions, and authorizations.
VIEW DEFINITIONpermission is sufficient to compare unencrypted objects in SQL Server 2005 or later databases. However, sysadmin permissions are required to decrypt encrypted stored procedures.
SELECTpermission for the system viewsys.sql_expression_dependencies. You may experience poor performance when comparing databases if you don't have this permission.
VIEW SERVER STATEpermissions to compare some encrypted objects.
For more general information on permissions, see your SQL Server documentation.