Permissions and Visual Database Tools (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.

See Also

Concepts

Multiuser Environments (Visual Database Tools)

Help and Information

Getting SQL Server 2005 Assistance