题目内容

You are adatabase developer. You develop atask management application that connect stoa SQLServer 2008 database named TaskDB.Users logon to the application by using a SQLServer login. The application contains amodule named Task that assigns tasks tousers. Information about the setasks is stored in the Tasks table of the TaskDB data base. The Tasks table contains multiple columns. These include the Close Dateand Estimated Timecolumns. The application must meet the following security requirements: Users assigned toad atabase role named User 1 canupd ate all task information columns except the Close Date and the Estimated Time columns in the Tasks table. Administrative users assigned toad atabase role named Task_Admin canupd ateall task information in the Tasks table.You needto design a strategy to meet the security requirements. Which two actions should you perform?()

Add the Task_Admin role to thedb_accessadmin fixed database role.
B. Grant Update permissions on the Tasks table to the Task_Admin role.
C. Grant Update permissions on the Tasks table to the User 1 role foreach column except the Close Dateand Estimated Time columns.
D. Createan INSTEAD OF trigger on the Tasks Table. Use theIs_Member function toprevent the User 1 role from updating the Close Date and Estimated Time columns.

查看答案
更多问题

常用的概念测试方法有()

A. 小组讨论法
B. 机械测定法
C. 问卷调查法
D. 认知列表法
E. 语句完成法

关于医院感染下列哪项是错误的()。

A. 是指住院病人在医院内获得的感染
B. 包括在住院期间发生的感染和茬医院内获得出院后发生的感染
C. 包括入院前已开始或入院时已处于潜伏期的感染
D. 医院工作人员在医院内获得的感染也属医院感染

离心泵的轴封结构有()、机械密封两种。

下列哪些是新生儿易患败血症的解剖生理特点

A. 免疫功能不成熟
B. 血清补体较高
C. 皮肤粘膜薄嫩
D. 网状内皮系统功能不成熟
E. 血清IgIgM缺乏

答案查题题库