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-22614: error while construction the collection in the image

1 Answers  


ORA-06512: at stringline string

1 Answers  


ORA-07703: error in archive text: need '/' after device type

1 Answers  


DRG-12010: This file already exists - replace existing file?

1 Answers  


ORA-30682: improper value for argument OPTION_FLAGS

1 Answers  


NNL-00306: Server setting all statistic counters to zero

1 Answers  


ORA-02084: database name is missing a component

1 Answers  


TNS-01033: Listener Parameter File string

1 Answers  


ORA-19618: cannot name files after restoreValidate has been called

1 Answers  


ORA-36718: (XSALLOC00) You do not have the necessary permissions to use AGGMAP workspace object.

1 Answers  


SQL-02152: Invalid numeric variable for use in an array GET/SET statement

1 Answers  


ORA-02215: duplicate tablespace name clause

1 Answers  


Categories