Snippet

Restricting Sensitive Column Access via Security Views

Views serve as a fundamental security mechanism in SQL databases. Creating dedicated views allows database administrators to expose non-sensitive fields and pre-filtered active records to application users while hiding restricted columns like salaries or social security numbers.

snippet.sql

sql

CREATE VIEW public_employee_directory AS
SELECT
  employee_id,
  first_name,
  last_name,
  department_id
FROM employees
WHERE is_active = 1;

Breakdown

CREATE VIEW public_employee_directory AS

Defines a virtual table to encapsulate security and access rules.

employee_id,

Includes non-sensitive operational columns in the public projection.

FROM employees

References the base underlying relation containing complete workforce data.

WHERE is_active = 1;

Filters out inactive employee records automatically for all consumers of this view.

Previous snippet Next snippet

More Intermediate SQL exercises →

Restricting Sensitive Column Access via Security Views

Related