OraFAQ Forum: Security » Lock out user between specific times

Home » RDBMS Server » Security » Lock out user between specific times (Oracle 10.2.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Lock out user between specific times [message #440015]

Wed, 20 January 2010 11:01

allie_jane
Messages: 1
Registered: August 2009
Location: Glasgow

Junior Member

Hi there,

Is it possible to lock an oracle user out of the database between specific times of the day?

I have users who I want to log into Business Objects XI and run adhock reports at night, but during the working day not to refresh the reports or run new ones.

BOXI doesn't have the functionality to stop this happening - I was hoping that I could do something with a on-logon trigger or a dbms_jobs?

I've looked into this but I was hoping that someone would have some live experience or advice.

Thanks

Alison

Report message to a moderator

[Message index]

		Lock out user between specific times By: allie_jane on Wed, 20 January 2010 11:01
		Re: Lock out user between specific times By: Michel Cadot on Wed, 20 January 2010 11:12
		Re: Lock out user between specific times By: smunir362 on Wed, 03 February 2010 09:47
		Re: Lock out user between specific times By: Michel Cadot on Wed, 03 February 2010 09:59
		Re: Lock out user between specific times By: smunir362 on Wed, 03 February 2010 10:03
		Re: Lock out user between specific times By: Michel Cadot on Wed, 03 February 2010 10:09

Previous Topic:	Privileges
Next Topic:	Oracle 11g Authenticationi via OpenLDAP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 22:37:01 CDT 2024