QuestionQ31

VerifiedData and Database Security

A database administrator must give multiple group users access to data from two separate tables to support ongoing reporting. However, certain columns in each table are restricted, and users must not be able to view the values in those columns.

Which of the following is the best action for the administrator to take?

Explanation

A view can present a defined selection of columns from one or more underlying tables, including joins where needed. Granting users access to that view while withholding access to the base tables lets them run ongoing reports without exposing restricted columns. Microsoft Learn describes views as a security mechanism that provides access through the view without direct permissions on the underlying base tables.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!