What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod.
Domain.com also has a Windows group named CertKillerManagers that makes use of CK_Prod.
Some of the users in that group are members for the db_owner role.
However, one member in the CertKillerManagers group named Mia is not allowed to access the SQL Server instance.
You have received instructions from the CEO to make sure that the Mia does not access the instance.
You need to complete this task using the appropriate Transact-SQL statement.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod.
Domain.com also has a Windows group named CertKillerManagers that makes use of CK_Prod.
Some of the users in that group are members for the db_owner role.
However, one member in the CertKillerManagers group named Mia is not allowed to access the SQL Server instance.
You have received instructions from the CEO to make sure that the Mia does not access the instance.
You need to complete this task using the appropriate Transact-SQL statement.

What should you do?

A.
You should consider using the following:
EXEC dbo.sp_droprolemember ‘db_master’, "CertKillerMia";

B.
You should consider using the following:
DROP LOGIN "CertKillerMia";

C.
You should consider using the following:
CREATE LOGIN "MiaMia" FROM Windows; DENY CONNECT SQL TO " MiaMia ";

D.
You should consider using the following:
REMOVE LOGIN "CertKillerMia";



Leave a Reply 0

Your email address will not be published. Required fields are marked *