Permissions and Visual Database Tools
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 is controlled by your installation's security policy. If you do not 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. For more information, see How to: Generate Change Scripts.