Showing posts with label ORA-01954: DEFAULT ROLE clause not valid for CREATE USER. Show all posts
Showing posts with label ORA-01954: DEFAULT ROLE clause not valid for CREATE USER. Show all posts

Friday, 20 January 2012

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.