Get the App
SLTechnology News&Howtos  ›  Database  › 

Resolve the problem that oracle12c creates a user prompt ORA-65096: invalid public user name or role

Shulou Source: shulou.com Published: 2022-06-01 03:04:08 11月17日 Update

1. Background

I used to use oracle11g all the time, but I have no problem with creating users. Today, I reported an error when I created a user on oracle12c. As shown below:

I was so depressed that I opened the official oracle website and found that there was a limit to the creation of users.

two。 Solution

When you create a user, the user name starts with clocked # or Category #.

Misspelled: create user zhaojiedi identified by oracle

Correct way to write it: create user c##zhaojiedi identified by oracle

Note: if you don't worry about why, the above solution can meet your requirements, and you don't have to read the following.

=

=

3. Solution process

The following process is my process of solving this problem, which is also written and shared.

I have access to the oracle 12c official documentation

Go to the following pages in turn

Oracle12c home page

Administrator's Guide

Managing Users and Securing the Database

Oracle Database Security Guide

Creating User Accounts

After searching, the following figure is found on the Creating User Accounts page:

The above hint is very clear. To create a public user name, you must start with clocked # or clocked #. Our report above was wrong. It's because we create public users that don't start with clocked # or clocked #.

At this point, we know the specific cause of the error. Then there is a winning solution.

If you're still obsessed with what public and local users are, there's a profile on the Creating User Accounts page.

Summary

The above is introduced by the editor to solve the problem of oracle12c user prompt ORA-65096: invalid public user name or role. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. Thank you very much for your support to the website!

If you think this article is helpful to you, you are welcome to reprint it, please indicate the source, thank you!

Tags: User face user name problem beginning solution page public prompt content writing official website process error help role depressed no Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Shulou Information Shulou Tech Info Microsoft MySQL Xiaomi