Create local users in #Oracle 12c

By | March 16, 2019

One of the most annoying things is when some vendor decides that it is a good idea to change some very basic and long time existing basic behaviour.

In the new Oracle 12c you are no longer able to create local users the old way as sys:

CREATE USER my_app IDENTIFIED BY "pass";

If you try to execute the above the result is:

ORA-65096: invalid common user or role name

Now because of the new improved Oracle all this local users have to be prefixed by C##. But this creates a load of other problems and I do not want to brush through all the legacy SQL scripts one by one.

There is an undocumented fix for this. Enable the old way:

alter session set "_oracle_script"=true;

Contribute to this site maintenance !

This is a self hosted site, on own hardware and Internet connection. The old, down to earth way 🙂. If you think that you found something useful here please contribute. Choose the form below (default 1 EUR) or donate using Bitcoin (default 0.0001 BTC) using the QR code. Thank you !

€1.00

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.