可学答题网 > 问答 > MCTS(70-432)题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

You work in a 


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 Service in the instance. There is a database user who is named ServiceGreatUser. A SQL Server login named ServiceGreatLogin maps to ServiceGreatUser in the Service database. According to the requirement of the company CIO, the database user can only perform the two tasks below: the database user executes all stored procedures that currently exist in the Sales database and executes all stored procedures that will be created in the Sales database. So what should you do to ensure this? ()

  • AServiceGreatUser should be added to the appropriate fixed database roles. 
  • BYou should assign the appropriate object-level permissions to ServiceGreatUser 
  • CYou should assign the appropriate server-level permissions to ServiceGreatLogin 
  • DYou should assign the appropriate database-level permissions to ServiceGreatUser
参考答案
参考解析:
分类:MCTS(70-432)题库
相关推荐

1、You work in a 

You work in a company which is named Wiikigo Corp. The company uses SQL Server&#8...

2、You work in a 

You work in a data warehouse environment that involves the execution of complex queries...

3、You work in a 

You work in a company which uses SQL Server 2008. You are the administrator of&#8...

4、You work in a 

You work in a company which uses SQL Server 2008. You are the administrator of&#8...

5、You work in a 

You work in a company which uses SQL Server 2008. You are the administrator of&#8...

6、You work in a 

You work in a company which uses SQL Server 2008. You are the administrator of&#8...