Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Grant only for a part of a table?
Create a view and give the rights to the view
Eric
Nicolas Bronke escribió en mensaje <38147e7b_2_at_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 - 12:30:57 CDT