首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
52
问题
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
微软认证
相关试题推荐
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex
Supposeyouorderedahairdryeronlineatthecostof$22,butonlyreceivedanemptypackagebox.Somethingmustbewrong.Wri
SupposeyouphonedyourfriendMaryseveraltimesyesterdaybutshedidn’tansweryourcallatall.Writeheranemailto1
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
Herearesomemanagementtoolsthatcanbeusedtohelpyouleadapurposefullife.1.UseYourResourcesWisely.Yourdecisi
"Thisisareallyexcitingtime—aneweraisstarting,"saysPeterBazalgette,thechiefcreativeofficerofEndemol,thetelev
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
Writealettertorecommendyourstudent,LiXu,forapositionofadministratorinacompany.Youshouldincludethedetailsyo
在用户管理组administrators中删除lusi用户。
随机试题
刀具几何参数选择是否合理,也可以用刀具寿命来判断。()
因项目形成生产能力而发生的各种现金支出,包括购建固定资产的价款支出以及运输、安装、调试等方面的支出是指【】
对外地商品设定歧视性收费项目、实施歧视性收费标准,或者规定歧视性价格,这些行为的性质属于()
MFT50中的50表示()。
根据《反垄断法》的规定,下列关于市场支配地位推定的表述中,错误的是()。
根据所给材料,回答问题。照相术传入之初,被认为是“妖术”,能“摄取灵魂”。国人对于照相误解颇多,甚至引发了中西冲突。为此,有照相馆宣扬拍摄照片能摄去“衰运”。由此吸引了大批民众。当然,照相馆真正发展,还得依赖科技知识的传播和照相馆自身务实的探索。
胖尾效应是指统计学意义上的极端情况一反常态地经常出现的现象。根据上述定义,下列现象属于胖尾效应的是:
“理在事先。”这一观点属于
计算机控件用【】作为数据源。
Neitherthestudentsnortheteacher(know)______wheretohaveclass.
最新回复
(
0
)