Home » RDBMS Server » Security » Restricting users
Restricting users [message #233923] Sat, 28 April 2007 04:41 Go to next message
knight07
Messages: 8
Registered: April 2007
Junior Member
Hello oracle gurus:
I'm new to oracle but have a question about users.
Is there a way to restrict a user to log in from specific locations knowing the range of the IPs available from that locations?
And is it possible to limit the user (or group of users) to access few hours only during business day? (from example from 8:30 am - 1:30 pm).
Please help
Re: Restricting users [message #233947 is a reply to message #233923] Sat, 28 April 2007 07:23 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.oracle.com/technology/oramag/code/tips2007/030507.html
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:526822275627
Re: Restricting users [message #234088 is a reply to message #233947] Sun, 29 April 2007 16:24 Go to previous messageGo to next message
knight07
Messages: 8
Registered: April 2007
Junior Member
Thanx Rajendran for the very usefull links. Razz
Re: Restricting users [message #238731 is a reply to message #234088] Sat, 19 May 2007 14:15 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
CREATE A PROFILE
WITH CONNECT TIME AND THEN ASSIGN THE PROFILE TO THAT USER


CREATE PROFILE P LIMIT
CONNECT_TIME 300 ;

ALTER USER ABC PROFILE P;

AFTER 5 HOURS HE WILL DISCONNECT AUTOMATICALY
Re: Restricting users [message #238734 is a reply to message #238731] Sat, 19 May 2007 14:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
This does not answer OP's question. Not at all.
Reread carefully what is asking for.

Regards
Michel
Re: Restricting users [message #238735 is a reply to message #238734] Sat, 19 May 2007 14:23 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
i guess i gave hime answer of 2nd question


as far as the answer of 1st question may be create a function for ips and den call it in profile n den assign the profile to dat user;)

am i rite uncle cadot;) Laughing
Re: Restricting users [message #238739 is a reply to message #238735] Sat, 19 May 2007 14:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No, you're wrong for both questions.
Quote:
is it possible to limit the user (or group of users) to access few hours only during business day? (from example from 8:30 am - 1:30 pm).

He doesn't want to limit the duration of a session but the hours on the day.

For first question, what it is this function that can be called through profile? Tell where you can assign a function to a profile (but password verification function).

Please, english is not the first language of many people (including me) and so keep your post in standard english and not this... I don't know you say it in english.

Regards
Michel
Re: Restricting users [message #238755 is a reply to message #238739] Sat, 19 May 2007 16:46 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
As you call password verify function by runnging (utlpwdmg.sql)script and then the function name in profile.....like that you can create your own function and call it in profile.

not only reserved for password verify function you can call ur own function

[Updated on: Sat, 19 May 2007 16:48]

Report message to a moderator

Re: Restricting users [message #238757 is a reply to message #233923] Sat, 19 May 2007 16:58 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>not only reserved for password verify function you can call ur own function
Please demonstrate with reproducable example.
BTW what is "ur"?
Re: Restricting users [message #238759 is a reply to message #238757] Sat, 19 May 2007 17:02 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
as in profiles we call password function...is it?
now if we create a function according to our requirments and call that function in profile....
Re: Restricting users [message #238760 is a reply to message #233923] Sat, 19 May 2007 17:28 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>now if we create a function according to our requirments and call that function in profile....
Please demonstrate with reproducable example.
Re: Restricting users [message #238761 is a reply to message #238760] Sat, 19 May 2007 17:38 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
can we call only the fucntion creat by utlpwdmg.sql or any 1 we can call??
we call any function not only password verify function....in profile is it??

so now go and write customize function for password management and as well as what else you want to customize in that.
and then call it in profile.
Re: Restricting users [message #238764 is a reply to message #233923] Sat, 19 May 2007 18:47 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>so now go and write customize function for password management and as well as what else you want to customize in that.
>and then call it in profile.
Please demonstrate with reproducable example.
Re: Restricting users [message #238766 is a reply to message #238764] Sat, 19 May 2007 19:24 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
OKAY
i will when i have time to write function;)
Re: Restricting users [message #238779 is a reply to message #238766] Sat, 19 May 2007 23:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
DreamzZ,

Your posts are really really useless repeating the same peremptory words without proving them when we asked you for.

Regards
Michel

[Updated on: Sat, 19 May 2007 23:54]

Report message to a moderator

Re: Restricting users [message #238782 is a reply to message #233923] Sun, 20 May 2007 00:02 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Michel,
If you don't mind me asking, in which city do you reside/work?

I have a saying that is applicable in certain situations.

Redundancy is the best way to teach idiots.
Redundancy is the best way to teach idiots.
Redundancy is the best way to teach idiots.
Redundancy is the best way to teach idiots.

& sooner or later I finally learn the lesson.

HAND!
Re: Restricting users [message #238792 is a reply to message #238782] Sun, 20 May 2007 00:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Ana,

My previous post was for DreamzZ repeating again and again the same thing when you (rightly) repeat him to give an example.

I agree with you redundancy may be the only way to teach to some people.

I work exactly there:
http://maps.google.com/maps?f=q&hl=fr&ie=UTF8&om=1&ll=48.890681,2.232456&spn=0.076975,0.105572&z=13

Regards
Michel
Re: Restricting users [message #238795 is a reply to message #233923] Sun, 20 May 2007 00:47 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I am not a person who like "big cites", but I found Paris to be a delightful city.
With that being said I'd still rather live in SoCal.
http://www.camzone.com/
URL will show many local sites/attractions; even though this is not the best time of year to visit; May Gray or June gloom.

HAND!
Re: Restricting users [message #238797 is a reply to message #238795] Sun, 20 May 2007 01:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
I'm neither a big city person.
I have a look at your link and at San Diego page on Wikipedia. It seems a really nice place.

Regards
Michel
Re: Restricting users [message #238822 is a reply to message #238797] Sun, 20 May 2007 03:48 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
OK, those cities are nice, but the most beautiful place in the world is - and always will be - Lulungomeena.
Previous Topic: To know the user delete the table ?
Next Topic: oracle username & password
Goto Forum:
  


Current Time: Thu Dec 05 07:22:32 CST 2024