Minimal Permissions
What are minimal permissions required for certain operations?
- Run Profiler
- ALTER TRACE
- SSDT Import a database schema into project
- VIEW DEFINITION
- VIEW SERVER STATE
- If working with multiple databases use VIEW ANY DEFINITION run on master.
- SSDT Make schema updates (Publish)
- Add user to db_ddladmin role.
- Add to dbcreator server role to create new databases.