SQL Server permissions
Posted on 2013-05-22
ALthough not a SQL DBA myself, we have a SQL Server Healthcheck soon whereby I am told the assessor needs full access to the SQL Server Operating Systems and SQL Server itself. For the OS we can grant them temporary admin access, but for SQL Server, what would they need, do you need to grant them access to a database account per database, or would domain admin rights typically cover admin access to the SQL Servers as well?
Also how is likely they would access SQL Server, would they remote onto the Server? Or use tools locally on a designated PC?