Create User

iwl

Hi, I have installed XE and want to create some normal user as System.

Using just SQL Developer IDE I get "65096 invalid common user or role name"

In the tutorials the problems with creating some standard user weren't mentioned.

Solomon Yakobson

This means you are connecting to container database where only common & Oracle maintained users reside. You must connect to pluggable database.

SY.

iwl

There are so much Tables und Users with complicated Names when logged in as System.

How can I create an easy Environment with some tables to play around from 3rd party App?

cormaco

When you are logged in as SYSTEM in xepdb1 you can create your own users.

iwl

I can, but can't Login as, 01017, quite sure have with entered Username and Passwort.

Isn't there some complete tutorial to get environment like described or something similar.

cormaco

Here is one tutorial, I'm sure there are others:

https://www.oracletutorial.com/