首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
53
问题
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
微软认证
相关试题推荐
School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex
Writeanessayof160-200wordsbasedonthefollowingdrawing.Inyouressay,youshould1)describethedrawingbriefly,
Writeanessayof160~200wordsbasedonthefollowingdrawing.Inyouressay,youshould1)describethedrawingbriefly,
BarackObamaspentmuchtimeonthecampaigntrailproposingadramaticvisiontochangenotonlytheUnitedStatesforthebett
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
Herearesomemanagementtoolsthatcanbeusedtohelpyouleadapurposefullife.1.UseYourResourcesWisely.Yourdecisi
TheU.S.PostalService(USPS)continuestobleedredink.Itreportedanetlossof$5.6billionforfiscal2016,the10thst
Whateverhappenedtothedeathofnewspaper?Ayearagotheendseemednear.Therecessionthreatenedtoremovetheadvertising
Writealettertorecommendyourstudent,LiXu,forapositionofadministratorinacompany.Youshouldincludethedetailsyo
随机试题
企业会计组织机构内部分工的设计模式有哪些?
认为“组织行为学是一个研究领域,它探讨个体、群体以及结构对组织内部行为的影响,以便应用这些知识来改善组织的有效性”的学者是___________。
防止注射剂主药氧化的金属离子络合剂是()。
秦代某村村民甲性格乖张跋扈,不但欺凌乡里,对自己父母也时常打骂,某天,甲在对父母辱骂并要动手时,其父母忍无可忍,拿起铁棍将其打伤,后甲将其父母告至官府,则下列说法正确的有:
某人每月向保险公司交付200元,在年利率为8%时,则若这人想在10年后攒到15万元,所以每年向年利率为8%的银行存相同的钱,则他每年应存款()。
江泽民同志在党的十六大政治报告中指出.中国共产党坚持先进性和增强创造力的决定性因素是()。
Inthefirstparagraph,theinternetofPradaismentionedtoWhatdoestheword"antithetical"(Paragraph2)mostprobablymean
Youaregoingtoreadalistofheadingsandatextaboutnaturalselection.Choosethemostsuitableheadingfromthelistfor
数据模型的三个要素是()。
Incaseofpoisoning,immediatelygivelargequantitiesofsoapyorsaltywaterinorderto______vomiting.
最新回复
(
0
)