Oracle DBA, How To, Error, Cause and Action

ORA-01954: DEFAULT ROLE clause not valid for CREATE USER

ORA-01954: DEFAULT ROLE clause not valid for CREATE USER




Cause: Default roles cannot be specified for create user.




Action: Grant and alter the user's default roles after creating the user.