Oracle Error Message
ORA-01954: DEFAULT ROLE clause not valid for CREATE USER
Reason for the Error
Default roles cannot be specified for create user.
Solution
Grant and alter the user’s default roles after creating the user.
ORA-01954: DEFAULT ROLE clause not valid for CREATE USER
Default roles cannot be specified for create user.
Grant and alter the user’s default roles after creating the user.