What is going to be the minimum permissions or role memberships that a DB developer will need in order to be able to import a schema from a DB into the tool?
Is there a way to prevent any developer from importing the schema from a certain DB?
Thanks,
AW
Within the Import schema option, you first need to create a connection to your database with your user name and password. Whatever permissions that user name has on the SQL Server, the Import Schema option will respect.
so for example if I create a connection to my SQL Server instance using my NT username which is a DBO for a given database then I can import all the schema objects that the DBO user has read permissions to.
We basically respect the DB/Server permissions settings
mairead
