If a database administrator wants to allow middle management members to see their departments’ profits and expenses but not show them the whole company’s profits,what can she implement?
A.
ADO
B.
OLE-DM
C.
Views
D.
DBMS
Explanation:
Databases can permit one group, or a specific user, to see certain information while restricting another group from viewing it altogether. This functionality happens through the use of database view. If a database administrator wants to allow middle management members to see their departments’ profits and expenses but not show them the whole company’s profits, she can implement views.Senior management would be given all views, which contain all the departments’ and the company’s profit and expense values, whereas each individual manager would onlybe able to view his or her department values.