A: Preface
These days I re-installed the computer, and then I have tried to install the next oracle11g, the result still failed and then I went to download the latest oracle12c,oracle12c in two users sys and System,scott have no, So I wanted to create a user of my own.
Two: the problem
I've tried it many times. "ORA-65096: Public user name or role name is invalid", finally Baidu only know, the wording is such as "Create User C # #xxx identified by xxx"; Because now you are creating a user under the CBD, CBD Full name container database, Chinese translation as a data base container, there is a pdb,pdb all called the pluggable database, you can plug and Unplug databases.
The next issue is authorization.
On the Internet to find the licensing situation, divided into three kinds, connect role,resource role,dba role
(i): Connect role
Connect role is mainly to give the user permissions to the table operation, such as the table Select, Delete, Updata, insert, and so on, so connect is at this point will make sense, with connect role users can also create tables, views , sequences (sequence), clusters (cluster), synonyms (synonym), sessions (session), and links to other databases (link);
(ii): Resource role
Online is said to be more reliable and formal database users can grant resource role, in fact, I do not quite understand this sentence, but I looked at the following instructions to know when God should be given permission on it.; Resource gives users additional permissions to create their own tables, sequences, procedures ( Procedure), triggers (trigger), index (index), and cluster (cluster).
(iii): DBA role
The DBA has all of the system permissions. Includes unlimited space limits and the ability to grant various permissions to other users. System is owned by the DBA user.
Authorization I also experiment, with the original form or not, must be in this "Grant Connect,resource to C # #xxx;"
Now that you can authorize or cancel the authorization
Cancellation authorization is: Revoke connect, resource from C # #XXX;