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.
For more general information on permissions, see your SQL Server documentation.