Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Grant only for a part of a table?

Grant only for a part of a table?

From: Nicolas Bronke <newsgroup_at_trinity.de>
Date: Mon, 25 Oct 1999 18:40:26 +0200
Message-ID: <38147e7b_2@news2.prserv.net> 





Is it possible, to limit grant rights for a table depending on a where
clause or like that?



E.g. Table Customer and Orders


Now a customer shall have a look at Orders but limited to his customer Ids.
Is that possible using any grant option or does I have to create special
views or have to program it inside the application?



Thanks for any comment.



Regards


Nicolas Bronke


Received on Mon Oct 25 1999 - 11:40:26 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US