| How to add conditions to user passwords [message #273009] |
Mon, 08 October 2007 11:23  |
coolboy2005in
Messages: 12
Registered: July 2007
Location: Herndon
|
Junior Member |
|
|
I have oracle 10g release 2. The OS is RHEL4.
I am facing a problem. For SOX compliance our security officer wants user password to have some conditions to make it tougher. So he is asking us about ways by which we can attach conditions to the user passwords. Something like:
The password should have at least 2 numbers, 1 special character and 1 or more character.
Thanks in advance...
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: How to add conditions to user passwords [message #273217 is a reply to message #273145] |
Tue, 09 October 2007 10:09  |
coolboy2005in
Messages: 12
Registered: July 2007
Location: Herndon
|
Junior Member |
|
|
Thanks rikfair & Arju,
I knew about profile I was just looking for this info not everything about profile.
PASSWORD_VERIFY_FUNCTION: The function used to check password complexity.
I don't get the use of this forum as theoretically Google can give us everything (Remember it even searches oracle documentation).
Thanks for helping me guys and sorry to the geeks who found this topic stupid.
|
|
|
|
|
|
| Re: How to add conditions to user passwords [message #273241 is a reply to message #273217] |
Tue, 09 October 2007 12:29 |
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
|
Senior Member |
|
|
| Quote: |
Thanks for helping me guys and sorry to the geeks who found this topic stupid.
|
coolboy. Exactly where do you get off insulting me (or trying to anyway - I'm proud to be a geek) and the others of this forum who refuse to spoon feed the lazy?! I supplied you with the required search topic which would answer your question. The tone of your op implied that you had no knowledge of Profiles. As Michel points out, if you knew about profiles then you wouldn't have needed to ask how:| Quote: |
we can attach conditions to the user passwords. Something like:
The password should have at least 2 numbers, 1 special character and 1 or more character.
|
You would have known that Profiles would be where you should be looking for such a task. You clearly did not know this. Or presumably, since you know about profiles, it was just that you want spoon fed because you can't be bothered looking at some documentation.
| Quote: |
I don't get the use of this forum as theoretically Google can give us everything
|
patently untrue. Apart from the fact that you need to know what to search for, you will not always find the exact answer to your specific situation which may have special circumstances. We have no problem going down to the minutiae but you've got to show that you have at least put in a bit of effort and you're not just expecting others to do your work for you. You asked a very general question. You get a general answer. Read up on the topic you were pointed to, and if you have problems, come back and ask with the specifics of your lack of understanding. If your question is simply
"How do I perform this very general, commonly performed task which is well documented and relatively easily performed" Damn right I'm going to point you in no more than the right direction. If you come back and say
"I've performed these following tasks, I was expecting this result, but that isn't what I'm getting, I'm actually getting XYZ - here is the copy of my session to show what I'm taliking about" you will get both help and respect. At this point, from me, you will get neither.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
