Opened 9 years ago
Last modified 9 years ago
#27420 closed Bug
Oracle DB test user password error — at Initial Version
| 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
Oracle DB test user password can not 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.
Note:
See TracTickets
for help on using tickets.