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;