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.