Edit

Permissions and Visual Database Tools (Visual Database Tools)

Applies to: SQL Server

Permissions, which allow users access to data source objects, are granted in the data source, not in Visual Database Tools. The access permissions granted on data source objects are controlled by your installation's security policy. If you don't have permission to access certain database objects, you should contact your database administrator.

If the database permissions let you view but not modify the database structure, you can use change scripts to design your modifications without transmitting them to the database.