Explanation:To see other logins, requires ALTER ANY LOGIN, or a permission on the login. 9. To add or remove server role membership use :
A. ALTER ROLE
B. ALTER ANY LOGIN
C. ALTER SERVER ROLE
D. None of the mentioned
Answer:A
Explanation:To see other logins, requires ALTER ANY LOGIN, or a permission on the login. 9. To add or remove server role membership use :
A. ALTER ROLE B. ALTER ANY LOGIN C. ALTER SERVER ROLE D. None of the mentioned
Explanation:ALTER SERVER ROLE changes the membership of a server role or changes name of a user-defined server role. Fixed server roles cannot be renamed. 10. What is the role of WITH NAME in the following code ?