Fehlerbericht - ORA-65096: Ungültiger allgemeiner Benutzer- oder Rollenname 65096. 00000 - "invalid common user or role name" *Cause: An attempt was made to create a common user or role with a name that was not valid for common users or roles. In addition to the usual rules for user and role names, common user and role names must start with C## or c## and consist only of ASCII characters. *Action: Specify a valid common user or role name.
googling around I find that you must preceed the commmand with:
alter session set "_ORACLE_SCRIPT"=true;
create user PIPPO IDENTIFIED BY PIPPO;
grant create session to PIPPO;
GRANT CONNECT, RESOURCE, CREATE VIEW TO PIPPO;
GRANT ALL PRIVILEGES to PIPPO;
create table USERS (id NUMBER GENERATED BY DEFAULT AS IDENTITY, name varchar(100) );
This is simply ridiculous.
No comments:
Post a Comment