Oracle SQL

Create User ERROR: ORA-01017

ERROR: ORA-01017: invalid username/password; logon denied

image

If you got

ERROR at line 1:

ORA-00922: missing or invalid option

Then you alter the session:

SQL> alter session set “_oracle_script”=true;

image 1

How can you create the user and then connect the user?

But when you try to connect, you get an error.

image 2

So, if you need to solve this issue, grant the permission.

image 3

About the author

shohal

Leave a Comment