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-26682: invalid value for publication_on

1 Answers  


ORA-14000: only one LOCAL clause may be specified

1 Answers  


ORA-25267: didnt specify the signature for a reciever non-repudiable queue

1 Answers  


ORA-06301: IPA: Cannot allocate driver context

1 Answers  


ORA-31415: change set string does not exist

1 Answers  






ORA-31055: A null XMLType element cannot be inserted into RESOURCE_VIEW

1 Answers  


TNS-12547: TNS:lost contact

1 Answers  


RMAN-06543: duplicate or conflicting LIST options: string and string

1 Answers  


ORA-23417: unknown materialized view type: string

1 Answers  


DRG-11525: invalid commitafter parameter of string specified

1 Answers  


ORA-01138: database must either be open in this instance or not at all

2 Answers  


ORA-38409: invalid name or option for the attribute set: string

1 Answers  


Categories