SQL Access Check | Dataford Interview Questions

Write a query to determine if a user can access a specific project.

Evaluate user 2 for project 104. A user can access the project only when both records exist and the user has an active membership for that project.

Output

Return exactly one row with user_id, project_id, and can_access.
can_access must be a Boolean value.
Preserve the requested identifiers even when access is denied.

Schema

users

Column	Type	Description
user_idPK	INT	Unique user identifier
user_name	VARCHAR(100)	User display name
email	VARCHAR(150)	User email address

projects

Column	Type	Description
project_idPK	INT	Unique project identifier
project_name	VARCHAR(150)	Project name
owner_user_id	INT	User who owns the project

project_memberships

Column	Type	Description
membership_idPK	INT	Unique membership identifier
user_id	INT	Referenced user
project_id	INT	Referenced project
role	VARCHAR(30)	Membership role
is_active	BOOLEAN	Whether the membership currently grants access

Your question is SQL Access Check. Start with the requirements and the three tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem