have access to SINs</li>
<li>Access to the base employee table, with SINs, can be granted to some employees (or to some roles if using role-based access control)</li>
<li>A view on top of the employee table can be created without the SINs, and access to other employees can be granted on the view</li>
</ul>
<div class="sourceCode" id="cb5"><pre class="sourceCode sql"><code class="sourceCode sql"><span id="cb5-1"><a href="#cb5-1" aria-hidden="true"></a><span class="kw">drop</span> <span class="kw">schema</spa