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



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

Answer / guest

Cause: Default roles cannot be specified for create user.

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-28024: must revoke grants of external roles to this role/user

1 Answers  


ORA-02882: sou2o: Could not register SGA for protection

1 Answers  


ORA-32123: Attribute number is out of range

1 Answers  


TNS-00079: * log_off - ask process_name to turn logging off

1 Answers  


PCB-00628: Buffer type is incompatible with LOB type

1 Answers  


DRG-10531: parallel parameter must be > 0

1 Answers  


O2I-00112: Unable to write to the HFILE file

1 Answers  


QSM-02008: non-join filter condition in WHERE or HAVING clause

1 Answers  


ORA-28661: Object already has COMPRESS clause specified

1 Answers  


ORA-38304: missing or invalid user name

1 Answers  


NZE-29162: Non-FIPS cipher suites being used in FIPS mode.

1 Answers  


ORA-38503: index already defined using the parameters

1 Answers  


Categories