Snippet

Enhancing Database Security with Views

A view provides a restricted virtual table that exposes only non-sensitive columns, preventing unauthorized access to confidential fields like passwords or social security numbers.

snippet.sql

sql

CREATE VIEW public_user_profiles AS
SELECT user_id, username, created_at
FROM users;

Breakdown

CREATE VIEW public_user_profiles AS

Creates a virtual table named public_user_profiles.

SELECT user_id, username, created_at

Chooses only the safe, public columns to be exposed.

FROM users;

Points to the underlying users table containing the raw data.

Previous snippet Next snippet

More Beginner SQL exercises →

Enhancing Database Security with Views

Related