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
|
|
|
|
|
|
|
Re: Lock out user between specific times [message #441876 is a reply to message #441874] |
Wed, 03 February 2010 10:09 |
|
Michel Cadot
Messages: 68659 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
If an account has CREATE SESSION only in a secure applicatin role then it can NEVER connect as it must be connected to be able to activate the role.
So you cannot disable CREATE SESSION by a secure application role.
Regards
Michel
|
|
|