题目内容

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? ()

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

查看答案
更多问题

1安培等于()微安.

A. 103
B. 106
C. 109

对电工仪表如何进行正常维护?

糖类物质中,不具有甜味的是()

A. 单糖
B. 双糖
C. 多糖

2016年义务兵家庭优待金标准是19633元/年。

A. 正确
B. 错误

答案查题题库