Re: Grant only for a part of a table?

From: William Hancock <Hancock.William_at_worldnet.att.net>
Date: Thu, 28 Oct 1999 19:43:53 -0500
Message-ID: <3818EDC9.3745FBA@worldnet.att.net>

This is one of the fundamental uses of views.  You'll need to join somehow to a
table which relates the user to his orders and use the function USER(which returns the Oracle username logged on in the current session).  Say you have a table of oracle usernames and customer id's and another of orders with customer id's, then the view should say something like

where USER=custusers.username and orders.customer_id=custusers.customer_id

or some such.

Nicolas Bronke wrote:

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 Thu Oct 28 1999 - 19:43:53 CDT