Home » SQL & PL/SQL » SQL & PL/SQL » ALTER USER with COMPLEX PASSWORD (9.2.0.8)
ALTER USER with COMPLEX PASSWORD [message #304528] Wed, 05 March 2008 09:08 Go to next message
anjum.suri
Messages: 14
Registered: February 2008
Junior Member
Hi All

I have a question regarding ALTER USER statement; I need to specify " (double quotes, single quotes) and other special charachters) in my ALTER USER abc IDENTIFIED BY statement; how is that possible? Few examples could be

Test|"
p”ssw0rd --> missing double quote in identifier
p(ssw0rd --> missing or invalid option
"p(ssw0rd" --> This works

can anyone suggest me how to make this possible to except double quotes (but only once in a password)

Thanks
Re: ALTER USER with COMPLEX PASSWORD [message #304547 is a reply to message #304528] Wed, 05 March 2008 10:31 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
" is not a valid character.
This is explained in documentation: ALTER USER

But you don't read it as you don't read the warning in the forum description: "Newbies should not post to this forum!"
And the expert notion defined in the sticky: Not an EXPERT? Post in the NEWBIES forum, NOT here
And the rules described in: OraFAQ Forum Guide

Regards
Michel
Previous Topic: dbms_job.submit error
Next Topic: merged again: 2000+ selects, fill rates
Goto Forum:
  


Current Time: Thu Dec 08 16:31:35 CST 2016

Total time taken to generate the page: 0.10934 seconds