Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Restrict data acces by period

Re: Restrict data acces by period

From: <>
Date: 6 Nov 2006 13:54:26 -0800
Message-ID: <>

comments embedded.
Beto wrote:
> Hi All ,
> I'm using a third party client application and one of the functionality
> is to access the bills of each user and the allowed period to access
> the bills is 1 year.

And this is by design from the vendor.

> This access is made by queries in some tables , but
> through hard coded queries...I would like to reduce the period of acces
> to some months only but without changes in the client...

To do that you'd either need to use views (which would necessitate changing the client code) or re-write the queries (which would necessitate changing the client code), something I doubt you have permission to do as the vendor would need to approve such changes before you implemented them else you risk losing all support for this application.

> Is it possible
> to restrict data access into database or in tables directly by
> period?

With a properly written query or a view, yes.

> My database use oracle 8.

That's a broad categorization as '8' could reference any release from 8.0.x to 8.1.7.x, inclusive, and all of the various releases change functionality (usually for the better) as one traverses the list from 8.0.x to 8.1.7.x. What is available in 8.1.7.x may not be available in 8.0.x, rendering any assistance futile until you provide all four numbers of your Oracle release. But, even in that broad expanse of Oracle releases I doubt there is anything to available to help you in what you're wanting to do here. Have you thought of bringing this to the attention of the software vendor, and see if they provide such modifications to their code? It would appear to be a minor change to satisfy a client.

> Thanks in advance!
> rgds,

David Fitzjarrell Received on Mon Nov 06 2006 - 15:54:26 CST

Original text of this message