User Creation [message #144506] |
Wed, 26 October 2005 19:01 |
hexmanju
Messages: 78 Registered: September 2005 Location: MUMBAI
|
Member |
|
|
Hi,
Being a Junior DBA in my firm i also have a job of creating Users in Oracle....
So whenever i create a user i assign a password policy to them..,Basically the verify_function we can say... my verify_function is designed in such a way that the password should have alteast one digit,one special and minimum 8 letters..
So i created a User as
CREATE USER ZZMANJU IDENTIFIED BY HITISI11!
DEFAULT TABLESPACE HSTABLE
TEMPORARY TABLESPACE HSTEMP
PROFILE PASSWORD_POLICY;
When i issue this statement i get an error as
"missing or invalid option at line 1"
So what i did is i issued a statement like
CREATE USER ZZMANJU IDENTIFIED BY "HITISI11!"
DEFAULT TABLESPACE HSTABLE
TEMPORARY TABLESPACE HSTEMP
PROFILE PASSWORD_POLICY;
i.e password in quotes ..
It worked....
Maybe it did not work in the first statement because of the special character !.Also @ may not work...But my password policy allows ! as well as @ as special characters for passwords...
So,please tell me a strong reason behind this..
Thanks
Manju
|
|
|
|
|
|
|