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 -> Re: Can i restrict user to query database table after office time....

Re: Can i restrict user to query database table after office time....

From: Igor Racic <igor.racicC_at_freesurf.fr_no_C>
Date: Sat, 01 Jan 2005 20:20:24 +0000
Message-ID: <41d6f709$0$21777$636a15ce@news.free.fr>


>
> The suggestion to use a view that others have made is fine. It's cheap,
> it works, and it will require you to re-write your application code so
> that it knows to query the view and not the table directly. If that last
> minor detail is not possible, and if you are using the Enterprise

  Or, in case of limited ways of DML to that tables, one sub-scenario could be (to avoid to change all code): rename tables, create views with old table names and change code where needed...

  Igor Received on Sat Jan 01 2005 - 14:20:24 CST

Original text of this message

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