what if you put "" around it?











"Robert Meier" <[EMAIL PROTECTED]>
03/10/2004 04:19 AM

 
        To:     <[EMAIL PROTECTED]>
        cc:     (bcc: Josh Ralph/IS/Expeditors)
        Subject:        Password Spec's


Hi,
 
Just a quick question, which characters are allowed in passwords for
users such as DOMAIN, SUPERDBA and CONTROL? When I try to use characters
such as ?,*,$ etc I seem to pickup endless problems with dbmcli esp.
loading the systabs and other areas!
 
If these characters are not allowed then surely it adds a bit of a
security risk?
 
If they are allowed, why do you pick up errors like i.e
 
dbmcli on QAS>load_systab -u superdba,P?0!3DSF[HEAD] -ud P?0!3DSF[HEAD]
ERR
-24964,ERR_EXECUTE: error in program execution
1,""F:\SAPDB\QAS\DB\bin\x_python" "F:\SAPDB\QAS\DB\env\lsystab.py" -d
QAS -u sup
erdba,* -dompwd P?0!3DSF[HEAD]   en ENG"
Traceback (innermost last):
  File "F:\SAPDB\QAS\DB\env\lsystab.py", line 171, in ?
    connectAndInstall (install, install.__doc__)
  File "F:\SAPDB\QAS\DB\env\installib.py", line 327, in
connectAndInstall
    session = connect (options)
  File "F:\SAPDB\QAS\DB\env\installib.py", line 298, in connect
    session.cmd ('use user %s %s' % (username, pwd))
loader.LoaderError: loader.LoaderError: [-25281] Syntax error at
position 20 (Un
expected token: ?).
 
 
when password is placed inside ' ie. 'P?0!3DSF[HEAD]'
ERR
-24988,ERR_SQL: sql error
 
when password is placed inside " ie. "P?0!3DSF[HEAD]"
ERR
-24907,ERR_DBAWRONG: wrong SYSDBA
 
and how can I get around this?
 
Thanks,
Robert




-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to