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
