title: How to grant permissions to a row in Oracle?
body: <p>I have a table with different persons belonging to different clients:</p>
  
  <pre><code>CREATE TABLE CLIENTS
  (
    CLIENT    VARCHAR2(20),
    FIRSTNAME VARCHAR2(20)
  )
  </code></pre>
  
  <p>Example data:</p>
  
  <pre><code>INSERT INTO CLIENTS (CLIENT, FIRSTNAME) VALUES ('A Corp.', 'Alice')
  INSERT INTO CLIENTS (CLIENT, FIRSTNAME) VALUES ('B Corp.', 'Bob')
  </code></pre>
  
  <p>Now I want to grant the permission to change the first name of all rows of the 'A Corp.' to person A and the rows of 'B Corp.' to person B.  I think it might be possible by creating a view for each person. But is it also possible without creating dedicated grant views for each person?</p>