ORA-01938

Error: ORA-01938: IDENTIFIED BY must be specified for CREATE USER

Causa: Cannot create a user without specifying a password or IDENTIFIED EXTERNALLY.

Acción: Specify one of the password clauses.

COMENTARIOS:

por Fredy Ramirez | 29/03/2017 16:43:49

RE: ORA-01938

-- Create the user
create user PPM IDENTIFIED BY PPM
default tablespace USERS
temporary tablespace TEMP;
-- Grant/Revoke role privileges
grant connect to PPM;
grant resource to PPM;
-- Grant/Revoke system privileges
grant create table to PPM;
grant debug connect session to PPM;
grant select any table to PPM;
grant unlimited tablespace to PPM;