Implementing Row Level Security on SQL Server

Implementing row level security become very important if you are using SQL Server as warehouse or implementing multi tenancy.

[pvksmaheeth]

is there an option in SQL server, that the whole table data is encrypted and to view the original data I need two passwords, one for myself and the other for the client

[pvksmaheeth]

can we call this table level security ?

[juancarlostorresmachuca]

This is so helpful, is there any way to have your script?