id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
27420	Oracle DB test user password must be quoted if it starts with a number	Mariusz Felisiak	Mariusz Felisiak	"Oracle DB test user password cannot start with digits because quotation marks are missing in SQL. For example:

{{{#!sql
CREATE USER foo
IDENTIFIED BY 2fXHVnA9KRH4uTSSvV3fVDel4kyVum
DEFAULT TABLESPACE foo_tbls_test
TEMPORARY TABLESPACE foo_tbls_temp_test
QUOTA UNLIMITED ON foo_tbls_test;
}}}

is incorrect (`ORA-00922: missing or invalid option`) it should be:

{{{#!sql
CREATE USER foo
IDENTIFIED BY ""2fXHVnA9KRH4uTSSvV3fVDel4kyVum""
DEFAULT TABLESPACE foo_tbls_test
TEMPORARY TABLESPACE foo_tbls_temp_test
QUOTA UNLIMITED ON foo_tbls_test;
}}}

All versions are vulnerable ie 1.8.16, 1.9.11, 1.10.3 and master."	Bug	assigned	Database layer (models, ORM)	1.8	Release blocker				Accepted	1	0	0	0	0	0