Home » RDBMS Server » Security » login Based on particular time (Oracle 11g )
login Based on particular time [message #499656] Tue, 15 March 2011 11:54 Go to next message
faiz_hyd
Messages: 294
Registered: February 2006
Senior Member
Hi,

how can we create a user such that he can login only at a particular time of the day .
if he try's to login other than the Time assigned ,shouldn't allow.

Can we use oracle Security policy ? or any other Profile or settings please tell or any link which can he helpful.

Thanks

Re: login Based on particular time [message #499662 is a reply to message #499656] Tue, 15 March 2011 12:13 Go to previous messageGo to next message
Michel Cadot
Messages: 58619
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
how can we create a user such that he can login only at a particular time of the day .

No but you can create a logon trigger so that it rejects the connection out of the allowed hours.

Regards
Michel
Re: login Based on particular time [message #499665 is a reply to message #499662] Tue, 15 March 2011 12:19 Go to previous messageGo to next message
faiz_hyd
Messages: 294
Registered: February 2006
Senior Member
thanks michel for Quick Response,

so that trigger would be on sys.Users table correct,
any example of that trigger if you have please.

And is there performance concern to be taken for such triggers
will it effect all Uses Connecting to DB.

Thanks

[Updated on: Tue, 15 March 2011 12:21]

Report message to a moderator

Re: login Based on particular time [message #499667 is a reply to message #499665] Tue, 15 March 2011 12:22 Go to previous messageGo to next message
BlackSwan
Messages: 22528
Registered: January 2009
Senior Member
>any example of that trigger if you have please.
http://asktom.oracle.com
contains many fine coding examples

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: login Based on particular time [message #499668 is a reply to message #499665] Tue, 15 March 2011 12:23 Go to previous messageGo to next message
cookiemonster
Messages: 10853
Registered: September 2008
Location: Rainy Manchester
Senior Member
No. It would be a logon trigger. It's not based on a table.
Check the docs
Re: login Based on particular time [message #499683 is a reply to message #499668] Tue, 15 March 2011 12:58 Go to previous message
Michel Cadot
Messages: 58619
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And more specifically database_event

Quote:
will it effect all Uses Connecting to DB

As you can see, it could on all users or only one user.

Regards
Michel


[Updated on: Tue, 15 March 2011 13:00]

Report message to a moderator

Previous Topic: how to grant a percentage tablespace
Next Topic: show labels from Oracle Label Security
Goto Forum:
  


Current Time: Wed Jul 30 11:47:43 CDT 2014

Total time taken to generate the page: 0.09061 seconds