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

From: Chris Spierings <cs123.n0.spam_at_telstra.com>
Date: Wed, 29 Dec 2004 12:37:38 GMT
Message-ID: <myxAd.93310$K7.78875@news-server.bigpond.net.au>

"Gaurav" <gb4u09_at_yahoo.com> wrote in message news:67040838.0412290422.456bc348_at_posting.google.com...
> HI group,
> I have doubt, can i restrict user to query database table after office
> time....
> Please suggestme solution...is solution possible in single query
> Please mailme at gb4u09_at_yahoo.com...

There may be better ways but you could always resrtict them through a view

create or replace view v1
as select * from my table
where to_char(sysdate,'HH24') between 8 and 17;

I haven't tried but you may also be able to make a trigger that raised an error if the wrong user selected at the wrong time.

There's probably some built in feature for this that I haven't heard of anyway! Received on Wed Dec 29 2004 - 06:37:38 CST