Opened 8 years ago

Last modified 8 years ago

#27420 closed Bug

Oracle DB test user password must be quoted if it starts with a number — at Version 3

Reported by: Mariusz Felisiak Owned by: Mariusz Felisiak
Component: Database layer (models, ORM) Version: 1.8
Severity: Release blocker Keywords:
Cc: marti@… Triage Stage: Accepted
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description (last modified by Mariusz Felisiak)

Oracle DB test user password cannot start with digits because quotation marks are missing in SQL. For example:

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:

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.

Change History (3)

comment:1 by Tim Graham, 8 years ago

Has patch: set
Needs documentation: set
Severity: NormalRelease blocker
Summary: Oracle DB test user password errorOracle DB test user password must be quoted if it starts with a number
Triage Stage: UnreviewedAccepted
Version: master1.8

PR. This might explain some of the failures that have popped up on Jenkins. Release notes for 1.10.4, 1.9.12, and 1.8.17 are also needed.

comment:2 by Mariusz Felisiak, 8 years ago

Needs documentation: unset

I added release notes for 1.8.17/1.9.12/1.10.4.

comment:3 by Mariusz Felisiak, 8 years ago

Description: modified (diff)
Note: See TracTickets for help on using tickets.
Back to Top