Which SQL Server fixed server role can manage server-wide security logins and their properties?
Options
-
A.
securityadmin
-
B.
processadmin
-
C.
diskadmin
-
D.
More than one of the above
-
E.
None of the above
Correct Answer (Detailed Explanation is Below)
A.
securityadmin
Detailed Explanation
- securityadmin: Manages logins and their properties at the server level.
- It can grant, deny and revoke server-level permissions.
- Its privileges should be assigned carefully because they can have significant security implications.
OOps! You are currently offline.