SQL is it possible to add a WHERE clause to a GRANT SELECT statement?
<p>I would like to be able to grant read privileges to all information within a view except the rows where DOB is not empty (i.e. user can only read row where DOB is null). Is this possible? An example (which doesn't work that I would like to work) is:</p>

<pre><code>GRANT SELECT ON DRVADM WHERE DOB IS NULL TO user_2;
</code></pre>

<p>Thanks</p>