View to hide sensitive columns

SQL Medium 0 views
Back to Questions
Previous View with join for reporting Medium P Next Updatable view idea Medium N

Problem Description

Payroll(emp_id, salary, bank_account). Create view exposing emp_id and salary only.

Input Format

SQL DDL

Output Format

View created

Sample Test Case

Input:
Payroll
Output:
View created

Constraints

Do not expose bank_account
Please login to submit solutions and comments.

Solutions (0)

No solutions submitted yet. Be the first!

Discussion (0)

No comments yet. Start the discussion!

Prev Next