OraFAQ Forum: Security » login Based on particular time

Home » RDBMS Server » Security » login Based on particular time (Oracle 11g )

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

Tue, 15 March 2011 11:54

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

Report message to a moderator

Re: login Based on particular time [message #499662 is a reply to message #499656]

Tue, 15 March 2011 12:13

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: login Based on particular time [message #499665 is a reply to message #499662]

Tue, 15 March 2011 12:19

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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/

Report message to a moderator