Database Administration (MOSC)

MOSC Banner

Create a local user in CDB$ROOT

edited Jun 30, 2017 2:51AM in Database Administration (MOSC) 2 commentsAnswered

Hello Experts,

As per the Oracle Documentation, its not possible to create a local-user in CDB$ROOT, only common-users can be created in CDB$ROOT

I'm a little curious on why would Oracle put that restriction, does anyone know a reason of having this restriction ?

ORA-65049: creation of local user or role is not allowed in CDB$ROOT

Cause: An attempt was made to create a local user or role in CDB$ROOT.

Action: If trying to create a common user or role, specify CONTAINER=ALL.

Is there any hidden parameters which can by-pass this restriction ?

Regards

Kaushik

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center