title: Oracle: control access to data through views?
body: <p>I have a problem with controling access to data in a database. The data is a mix of price-data from my company and price-data bought from a data-provider and since they charge per user who can access their data I need to be able to limit the access to data.</p>
  
  <p>I have a scheme "DATA" which holds all price-data. I am thinking having 2 additional schemes (example: LIM_ACCESS and FULL_ACCESS) with VIEWS that is build on the DATA-scheme. example:</p>
  
  <pre><code>CREATE VIEW LIM_ACCESS.V_PRICES AS&lt;br&gt;
  SELECT [] FROM DATA.PRICES&lt;br&gt;
  WHERE SOURCE = [MyCompany]
  
  CREATE VIEW FULL_ACCESS.V_PRICES AS&lt;br&gt;
  SELECT [] FROM DATA.PRICES
  </code></pre>
  
  <p>But to my experience then the LIM_ACCESS- and FULL_ACCESS-schemes has to have select-privelige on the DATA-tables to create the views and then I am back to square 1.</p>
  
  <p>Being a novice in databases I feel there must be a relative simple solution to this so any advice or hint(if this question has been asked and answered before) is appreciated :-)</p>
  
  <p>Kind Regards,<br>
  Svend</p>