首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a database that contains 64 lookup tables. These tables store static data that should not change. H
You are the administrator of a database that contains 64 lookup tables. These tables store static data that should not change. H
admin
2009-05-19
54
问题
You are the administrator of a database that contains 64 lookup tables. These tables store static data that should not change. However, users report that some of this data is being changed. You need to prevent users from modifying the data.
You want to minimize changes to your security model and to your database applications. How should you modify the database?
选项
A、Create a filegroup named LOOKUP. Move the lookup tables to this filegroup. Select the read only check box for the filegroup.
B、Create a database role named datamodifier. Grant SELECT permissions to the datamodifier role. Add all users to the role.
C、Deny INSERT, UPDATE, and DELETE permissions for all users. Create stored procedures that modify data in all tables except lookup tables. Require users to modify data through these stored procedures.
D、Create a view of the lookup tables. Use the view to allow users access to the lookup tables.
答案
A
解析
Explanation: SQL Server 2000 allows filegroups other than the primary filegroup to be marked as readonly.
A filegroup that is marked read-only cannot be modified. Tables that must not be modified can be placed on a filegroup that can then be mark as read-only. This will prevents accidental updates.
Incorrect Answers:
B: This solution effectively permits all users to modify any table in the database, as they would all have SELECT permissions to the database.
C: This solution will effectively prevent all users from being able to performing these tasks on all tables in the database as they are denied permissions to run INSERT, UPDATE, or DELETE statements against the database. A better solution would be to apply the deny permissions at the table level of the lookup tables. This would, however, require unnecessary administrative time.
D: Views are virtual tables that are used to filter tables or rows that the users should not have access to, however, if the users have access to the base tables, they can still run INSERT, UPDATE, and DELETE statements against the base table.
转载请注明原文地址:https://kaotiyun.com/show/yuhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Climatechangeissupposedtounfoldslowly,overdecades.Butthatisnottrueupinthegreatwhitenorth,asthoseattending
WhentheresidentsofBuenosAireswanttochangethepesostheydonottrustintothedollarstheydo,theygotoacueva,or"
WhentheresidentsofBuenosAireswanttochangethepesostheydonottrustintothedollarstheydo,theygotoacueva,or"
TheBestMediatoUseThereareplentyofoptionsavailableforspreadingnews,suchasnewspapers,radio,TV,theInternet
"Thisisareallyexcitingtime—aneweraisstarting,"saysPeterBazalgette,thechiefcreativeofficerofEndemol,thetelev
Adealisadeal—except,apparently,whenEntergyisinvolved.Thecompany,amajorenergysupplierinNewEngland,provokedjus
Whateverhappenedtothedeathofnewspaper?Ayearagotheendseemednear.Therecessionthreatenedtoremovetheadvertising
设置网络打印机,不允许每个连接到该计算机的用户都使用该网络打印机,只允许用户Administrators和Powerusers使用本地打印机。
Thefollowingscenariowillbeusedforquestions29and30.Johnisanetworkadministratorandhasbeentoldbyoneofhisnet
随机试题
根据古诺模型,若在行业中寡头厂商的数量为m,则每个寡头厂商的均衡产量为()
骨蒸潮热,盗汗遗精,咳嗽咯血,舌红少苔,尺脉数而有力者,治宜选用
十一月份的英文缩写是九月份的英文缩写是
某投资者投资100000元场外认购LOF基金,假设管理人规定的认购费率为1%,则其可得到的认购份额为()份。
与反社会性人格障碍的特点不符合的是()。
《幼儿园工作规程》中明确规定幼儿园教育要以()为基本活动,寓教育于各项活动中。
阅读下列说明,回答问题,将解答写在答题纸的对应栏内。【说明】某软件的积分计算模块每天定时根据用户发布的文章数、文章阅读数来统计用户所获取的积分,用户分为普通用户和专家用户,两类用户具有不同的积分系数。图4-1是该模块的类图,图中属性和
以下叙述中正确的是______。
Father;______Daughter;Coming.Oh,I’mstarving.OhmyGod!What’sthat?Father:Ah,nowdon’tcomplain!
It’sthedreamofmanyanofficedweller:Retireextremelyearlyandtraveltheworldatyourown【C1】______.Butthenyourememb
最新回复
(
0
)