which role should you add John’s account?
You are the SQL administrator for your company. You have two SQL Server 2008 computers named SQL_corp and SQL_public.
Multiple databases reside on these two servers.
A new user named John has been hired in your department.
John must be able manage permissions for the SQL_corp server.
He should also be able to manage permissions on the Sales database on the SQL_public computer.
You should not grant John any permissions he does not need. To which role should you add John’s account?