oravirt / ansible-oracle-modules

Oracle modules for Ansible
MIT License
214 stars 159 forks source link

oracle_user with password_hash #139

Open sathishbbala opened 4 years ago

sathishbbala commented 4 years ago

Has anyone used oracle_user module with password_hash against a > 12c database? I get a SQL error ORA-00972: identifier is too long sql

Line number 163 must have single quotes instead of double quotes. That worked for me. if authentication_type == 'password': if (schema_password_hash): sql = 'create user %s identified by values \'%s\' ' % (schema, schema_password_hash) else:

Rendanic commented 2 years ago

Solved with #158