首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
75
问题
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
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
TheU.S.PostalService(USPS)continuestobleedredink.Itreportedanetlossof$5.6billionforfiscal2016,the10thst
Evenintraditionaloffices,"thelinguafrancaofcorporateAmericahasgottenmuchmoreemotionalandmuchmoreright-brained
Evenintraditionaloffices,"thelinguafrancaofcorporateAmericahasgottenmuchmoreemotionalandmuchmoreright-brained
Notlongago,chiefexecutiveofficers(CEOS)werelandedasheroes,leadersofthebraveneweconomy.BillGatesandJackWelchw
InToday’smanagement-theoryindustry,reputation—oratleastthecorporatekind—isa"strategicasset"thatcanbe"leveraged"
通过【网上邻居】查找网上计算机和共享文件资源,IP为“202.204.54.23”,主机名为administrator,共享文件夹名为“tools”。
随机试题
简述排架计算的主要内容。
下列对主动脉的叙述哪项是错误的:
10月龄北京犬,不断用嘴磨蹭地或用抓挠面部,检查发现该犬唇部,眼睛周围皮肤发红,脱毛,有红色和脓性疱疹,腹部有黄色痂皮,采集病健交接处病料镜检,发现多个大小不超过0.5mm,呈圆形,头部突出,有四对足,后两对足不超出体缘的虫体。该病原最可能是(
完带汤适用于带下瘸的哪种证候
某货物价格为218万欧元,卖方负责将货物从莫斯科运达北京指定地点交货,并负责支付相关进口税费。货物交付买方后风险转移给买方。该国际贸易价格术语应表示为()。
(2011年考试真题)关于金融业营业税计税营业额的下列表述中,正确的有()。
甲公司为一物流企业,经营国内、国际货物运输业务。由于拥有的货轮出现了减值迹象,甲公司于2×15年12月31日对其进行减值测试。相关资料如下:(1)甲公司以人民币为记账本位币,国内货物运输采用人民币结算,国际货物运输采用美元结算。(2)货轮采用年限平均法
“圆周角”是初中九年级的上册的内容,是在圆的基本概念和性质以及圆心角概念和性质的基础上对圆周角的性质的探索,圆周角的性质在圆的有关证明、作图、计算中有着广泛的应用。回答下列问题:分析圆周角与圆心角的不同。
老年人监护系统由一个社区监控中心及若干便携式监护仪组成,便携式监护仪可由老年人随身携带,时刻监测老年人的脉象。便携式监护仪的基本功能要求如下:a、通过在老年人手腕上佩戴的压电传感器检测脉搏信号,并根据脉搏信号来测算心脏功能是否异常,若异常,则自动向社区监
采用ADO对“职工管理.accdb”文件中“职工表”的字段“退休年龄”加5。SubSetAgePlus()DimcaAsNewADODB.Connection’连接对象DimrsAsNewADODB.Recordset’记录
最新回复
(
0
)