单项选择题
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. DB1 is available to a Windows group which is named WIIKIGO\Supervisors. A Windows user named User1 is a member of the WIIKIGO\Supervisors group. WIIKIGO\Supervisors is a member of the db_owner role in the DB1 database. You must make sure that the SQL Server instance is available to User1. In the DB1 database, which Transact-SQL statement(s) should you execute?（）
A. DROP LOGIN "WIIKIGO\User1";
B. EXEC dbo.sp_droprolemember 'db_owner', 'WIIKIGO\User1';
C. EXEC dbo.sp_revokedbaccess 'WIIKIGO\User1';EXEC dbo.sp_revokelogin 'WIIKIGO\User1';
D. CREATE LOGIN "WIIKIGO\User1" FROM Windows;DENY CONNECT SQL TO "WIIKIGO\User1";
相关考题
-
单项选择题
YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDB1intheinstance.DB1hasatablewhichisnamedTable01andastoredprocedurenamedProcedure01.Procedure01choosedatafromTable01byusingasp_executesqlTransact-SQLstatement.Youcompanysecurityrulesforbiduserstoaccesstablesdirectlyinanydatabase.Lookattheexceptionbelow:"Msg229,Level14,State5,Line1TheSELECTpermissionwasdeniedontheobject'Table01',database 'DB1',schema'dbo'."TheexceptionisraisedwhenProcedure01isexecutedbyusers.YoumustmakesurethateusercansuccessfullyexecuteProcedure1complyingwiththecompanyrules.Sowhatactionshouldyouperformtoachievethisgoal?（）
A.You should execute the GRANT SELECT ON dbo.Table01 TO User1 Transact-SQL statement.
B.You should execute the GRANT EXECUTE ON dbo.Procedure1 TO User1 Transact-SQL statement.
C.You should alter Procedure01 and add the WITH EXECUTE AS OWNER option to its header
D.You should alter Procedure01 and add the EXECUTE AS USER = 'dbo' option immediately before the call to the sp_executesql stored procedure. -
单项选择题
YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisatextfilewhichisnamedSQL01.logontheE:drive.ASQLServerAgentjobexecutesevery2minutesandlogsinformationtothetextfile.Yougetareportfromuserssayingthattheseverdoesn'tmakeresponse.Asthetechnicalsupport,youcheckandfindthattheSQLServerAgentservicedoesnotrunandtheSQLServerAgentjobnolongerfunctions.YouhavetoidentifythereasonwhytheSQLServerAgentserviceisunresponsive.Intheoptionsbelow,whichlogshouldyoucheck?（）
A.You should check SQL1.log
B.You should check SQLAGENT.OUT
C.You should check log_xx.trc
D.You should check ERRORLOG -
单项选择题
YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedServiceintheinstance.ThereisadatabaseuserwhoisnamedServiceGreatUser.ASQLServerloginnamedServiceGreatLoginmapstoServiceGreatUserintheServicedatabase.AccordingtotherequirementofthecompanyCIO,thedatabaseusercanonlyperformthetwotasksbelow:thedatabaseuserexecutesallstoredproceduresthatcurrentlyexistintheSalesdatabaseandexecutesallstoredproceduresthatwillbecreatedintheSalesdatabase.Sowhatshouldyoudotoensurethis?（）
A.ServiceGreatUser should be added to the appropriate fixed database roles.
B.You should assign the appropriate object-level permissions to ServiceGreatUser
C.You should assign the appropriate server-level permissions to ServiceGreatLogin
D.You should assign the appropriate database-level permissions to ServiceGreatUser
