error creating a user [message #23455] |
Tue, 10 December 2002 22:26 |
sha
Messages: 84 Registered: July 2002
|
Member |
|
|
Hi,
I am using oracle 9i.After the installation,I connected as sys user and executed the file utlpwdmg.sql.I got the following message.
profile created
function created
then I created a user as
create user username identified by password;
I am getting the following error.
ORA-28003: password verification for the specified password failed
ORA-20003: Password should contain at least one
digit, one character and one punctuation
Then I created like this
create user username identified by raj!1;
I am getting this error
ORA-00911: invalid character
How should I create a user?
one more thing, when I installed 9i, by default scott user will exists or not?User scott is not available.should I create it or run any file? do help me
regards,
shastri
|
|
|
Re: error creating a user [message #23462 is a reply to message #23455] |
Wed, 11 December 2002 07:19 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
it is expected behaviour when u run utlpwdmg.sql.
It imposes new userlevel(password) security features.
New passwords will have to contain: a character, a number, a punctuation, at least 4 characters to be different then the username .(something like UNIX passwords).
u can remove this restrictions if you want.
for typical installations SCOTT will be created.
If it is not created run $ORACLE_HOME/rdbms/admin/UTLSAMPL.SQL ( it used to be scott.sql)
|
|
|