Oracle creates a new user and authorizes ____oracle

CMD under

Sqlplus Carriage return

Enter system user (default to create user permissions)

Create user xxx identified by xxx;(must not be lost;

Created, but at this point the linked database will error the Oracle creation user Ora-01045:user lacks create session Privilege;logon denied.

is because the user is not assigned permission

Solution:

Law 1, grant create session to XXX;

Law 2, Grant connect, resource to XXX;

With these permissions,

Grant create any, table to xxx;

Otherwise the issue of insufficient authority will be reported.